Conditional formatting not providing desired result.

[donodackal]

Hello folks

I have a Pareto chart that  I would like to further distinguish the 20:80 list with the background colour to the cell %value. 

I applied the following steps under cell elements>Background Color:

However, I am not getting the desired results with cells that have more than 81% also getting the yellow background. I checked the data formatting and it's in %. Not sure what I am doing wrong here, any help would be appreciated. The snippet below is the result I am getting with the above rules:

Any help to make sure the colour formatting sticks to what is 80% and below is one colour and 81% and above is another colour would be appreciated. 

Cheers!

[Anonymous]

HI @donodackal,

Does any aggregate apply to your fields that enabled the conditional formatting? If that is the case, the conditional formatting rule will be based on the detailed records instead of aggregate field values.

For this scenario, I'd like to suggest you create a measure to calculate the aggregate value and use the calculated result as a condition to check and return the color code for formatting.

Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

[lbendlin]

Your rule will fail when the value is 80.5% .  Change the rules to say

> 80%    -  Blue

<= 80 % - Yellow

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523