This content has been marked as final. Show 2 replies
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