Barchart Colors based on Values

[#1]

Hello Experts,

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.

Thanks

San

[jpapador]

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

[Anonymous]

Hi,

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

Cheers

Neetha

[MarcoWedel · Accepted solution]

Hi,

one solution could be:

When using the Min/Max approach, you have to compare against the TOTAL min or max.

hope this helps

regards

Marco

[#5]

Awesome , Thank you Marco.. 🙂

Also, Thank you All 🙂

[MarcoWedel]

You're welcome

Regards

Marco