Set color bar by dimension's value

[Anonymous]

Hi!,

I am doing a bar chart with "Empresa" as dimention. The thing is that I want to change the color of one of the bar if Empresa = Omnicrom.

Chart:

I use this formula in colour:  If(Empresa='Omnicrom', Red(), Blue())

If I click Omnicrom the bar turns red but when the chart is without a selection all the values has the same colour and I want than Omnicrom always be red.

What can I do?

Thanks from Argentina!

[Gysbert_Wassenaar · Accepted solution]

Where do you use the formula for the color? Did you click on the + in front of the expression, select Background Color and then entered that expression in the Definition field?

[Anonymous]

I try and works! thanks very much.

[crusader_]

Hi,

I've made the same thing.

Here is result.