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 ?
Go to Solution.
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
View solution in original post
In additional to nvprasad 's reply, I build a sample to you. You may set conditional format as below.
You can download the pbix file from this link: Rules for Background color change in table is not working as expected
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.