Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi
go to
thats it
cheers
Lech
Hi
go to
thats it
cheers
Lech
Cheers Lech
does it work for you mate?
Works like a charm.
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