Forum Discussion
Calculation logic behind percent conditional formatting
Hi ryan-gao
As tested with Version: 2.71.5523.941 64-bit (July 2019),
The picture you provided is the the default rules.
It applies a red diamond to the lower 33% of your data, a yellow triangle to the middle 33%, and a green circle to the upper 33%.
So however you change it, it will show by default.
To create your own rule, please delete the default ones, then create new rules.
Please read more from the blog
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2019-feature-summary/#filterPane
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi juanli
Thanks for your reply, I know how this function works, and I'm curious about the calculation logic used for percentages, finally, I found an article explaining the problem https://www.powerbigeek.com/percentile-in-powerbi-conditional-formatting/
Thank you all the same