I have the following scenario, I am showing all students marks in bar chart, I would like to display Highest score in Green color, lowest score in Red color, rest all in regular gay color. how to give the color code?
I have used Rank function, but with this I can show only either Highest or Lowest color change not both at once. please help me.
On the expression tab hit the "+" next to the expression and you will see and option called background color. Enter your expression there.
If(Score = Max(Score), Green(), If(Score = Min(Score), Red(), RGB(125,125,125)))
You could also use rank in place of min and max
In Background color of the dimension/expression please give below syntax:
= If(Grade= 'Highest', RGB(168, 189, 11),
If(Grade= 'Lowest', RGB(228, 31, 31),RGB(125,125,125)))
Hope it helps