2 Replies Latest reply: Dec 12, 2012 8:02 AM by Matteo Sulis RSS

    How to color bars of a bar chart in different colours depending on the value showned

      Hi All,

      I'm asking for the Community help to solve this apparantly simple problem:

       

      I have a bar chart and every bar should be dyed in a specific color depending on its value.

       

      The expression I'm using in the "Base Colour" calculation is:

       

      if(avg([Assessment Value])<=2, Yellow(), if(avg([Assessment Value])>2 and avg([Assessment Value])<=3, LightGreen(), Green()))

       

      The expression showned by the chart is: vg([Assessment Value])

       

      Now if I filter to see a single column it has the right colour depending on its value, if I see more columns they all have the colour of the first bar.

       

       

      Thanks a lot for helping

       

      Matteo