3 Replies Latest reply: Aug 7, 2014 9:29 AM by Andrei Kaliahin RSS

    Set color bar by dimension's value

    Leandro Abad

      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:

       

      barchart.png

      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!