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