Conditional background colors with set analysis

[agomes1971]

Hi,

is it possible to format background colors with set analysis associated to a listbox ?

Please see attached.

Thanks in advance

[anbu1984]

Can you explain your requirement?

[JonnyPoole · Accepted solution]

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)))

[agomes1971]

It worked!!!