Bar Chart Highest Value Coloured

[Anonymous]

Hi all,

I've looked everywhere but I can't find my answer.

I'm trying to highlight the bar with the highest value in my bar chart by colouring it green.

Can anyone help?

Thanks

Gareth

[sunny_talwar · Accepted solution]

Use color expression:

If(Rank(YourExpression) = 1,Green(), Blue())

[MK_QSL]

Consider that you have below Bar Chart

Dimension

Customer

Expression

SUM(Sales)

Now go to Expression Tab

Click on + sign and write below expression in BackGround Color

IF(SUM(Sales) = Max(TOTAL Aggr(SUM(Sales),Customer)),Green())

[Anonymous]

Thank you so much everyone! Problem solved.

[sunny_talwar]

Here please find attached a sample:

[rustyfishbones]

You can try something like this in the Expression definition for the background color

[rustyfishbones]

I was too slow in my attempt to help