Using Conditional Formatting 9.16.21

[jonnyA]

I'm trying to Highlight the Provider % when the Provider % is 10% above or below the Group %.

So for example ...

• Yellow Highlighted Provider %'s are at least 10% below the Group %.
• Red circled Provider %'s are at least 10% above the Group %.

[v-xiaotang · Accepted solution]

Hi @jonnyA 

I have encountered a similar post before, here is the link, https://community.powerbi.com/t5/Desktop/Comparing-Column-Values-then-Conditional-Formatting-Based-O...,for your reference.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@jonnyA ,

a new color measure =

if([Provider %] >.1 && [Provider %] >[Group %], "White", "yellow")

Use this in conditional formatting using field value option

[jonnyA]

@amitchandak , could you provide a screen shot for the conditional formatting?