Conditional Format Using negative ranges

[NIP008]

Hi All 

I need to add a conditional format rule as follows:

If compliance greater than 5% (add a red icon)

If compliance greater than -5% (Add yellow icon)

If compliance is  between -5% and 5% (add a green icon)

I've tried this but it doesn't work:

Please help!

[v-cazheng-msft · Accepted solution]

Hi @NIP008,

May I know whether you still have problem on it? Is ‘Deviation’ in the Based on field a Measure? If it is, could you please tell me how you create it and the sample data used to create this Measure? In addition, are you using the latest version of Power BI Desktop(2.104.941.0 64-bit, April 2022)? Thanks in advance!

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[NIP008]

Hi

Thanks for your reply. Help no longer needed - I figured out the rules for my conditional formatting:

[v-cazheng-msft]

Hi @NIP008,

That's greate! Thanks for your reply!

Best Regards,

Community Support Team _ Caiyun