Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
is it possible to format background colors with set analysis associated to a listbox ?
Please see attached.
Thanks in advance
I think you are trying to get all year bars to be the same color depending on the selection in a list box.
I put in some extra code that in a chart will be more explicit that only 1 Area be evaluated. Use this on the 'background color' expression to color all bars the same:
=If( only( TOTAL aggr(only( TOTAL Area),Year)) = 'Litros', RGB(75, 172, 198),If( only( TOTAL aggr(only( total Area),Year)) = 'Outras Vendas', RGB(146, 208, 80), RGB(255, 192, 0)))
Can you explain your requirement?
I think you are trying to get all year bars to be the same color depending on the selection in a list box.
I put in some extra code that in a chart will be more explicit that only 1 Area be evaluated. Use this on the 'background color' expression to color all bars the same:
=If( only( TOTAL aggr(only( TOTAL Area),Year)) = 'Litros', RGB(75, 172, 198),If( only( TOTAL aggr(only( total Area),Year)) = 'Outras Vendas', RGB(146, 208, 80), RGB(255, 192, 0)))
It worked!!!