Conditional Formatting - top two values

[alisonpwallis]

Hi

I have a chart where I need the top two percentages for each year to be highlighted (either by background colour or text, it doesn't matter). The data relates to particular categories and I want to know which categories have the highest percentage each time. I have tried conditional formatting the background colour and using visual cues but neither of them seem to work. I also don't know how to highlight the max value and the one below.

Can anyone help out?

I've attached a sample

thanks

Alison

[morganaaron · Accepted solution]

Hi Alison,

Try inserting:

If(Rank(Count ({$ <[EffectiveTerm]={"201314","201213","201415"}>}[Current ID])/Count (TOTAL<[EffectiveTerm]>[Current ID]))<=2, LightGreen())

in the "Background Color" option for your expression. Swap out LightGreen() for whatever RGB() or Color() value you wanted.

[alisonpwallis]

That's great! Thank you so much.

Alison

[#4]

Please find attached file.

Hope it helps you.