Pie Chart Colour for Maximum Value

[#1]

Hi

I have a pie chart which shows Sum(Revenue) by Sales Channel.

What I would like to show is for the slice with the largest Sum(Revenue) to be coloured in Green, whilst all other slices to be in grey.

May I know what kind of expression should I be using? I've tried colour mix and IF but they're not working.

Thanks in advance!

[Lech_Miszkiewicz · Accepted solution]

Hi

go to

• your pie chart properties
• colours and legend
  • toggle from "auto" to "custom"
  • choose by expression
  • put expression: If(Rank(aggr(sum(Revenue),[Sales Channel]))=1,RGB(0,255,0), RGB(150,150,150))
  • modify rgb colors according to your colour needs
    

thats it

cheers

Lech

[#3]

Cheers Lech

[Lech_Miszkiewicz]

does it work for you mate?

[#5]

Works like a charm.

[Lech_Miszkiewicz]

the only thing is that if there are null values in your dimension they will get a default "grey-ish" color.  I hope it is not a problem. Ultimately you may want to disable null values in dimension settings.

cheers

Lech