Rules for Background color change in table is not working as expected

[Anonymous]

I have a calculated measure called complete%. That is one of my field in table view. Given the below rules for background color.

In below report you could see, the colors are as expected.

However once i filter the whole report by clicking on pie chart, the colors are not followed as per the rules. How this can be corrected ?

[v-rzhou-msft]

Hi @Anonymous 

In additional to nvprasad 's reply, I build a sample to you. You may set conditional format as below.

Result:

You can download the pbix file from this link: Rules for Background color change in table is not working as expected

Best Regards,

Rico Zhou

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

[nvprasad · Accepted solution]

Hi 

While creating a rule, instead of using percentage in the dropdown try use number. (For ex: 10% means 0.1 as number. )

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad