Forum Discussion
Calculation logic behind percent conditional formatting
The default logic is Pct of min and max values. Your min is 0 and max is 10. So the breaks will be auto set at 3.3, 6.6
in your case, your settings are not MECE. If you change your third setting to start at 34, I assume it will work. My guess is this is a bug.
Thanks Matt, Yes, My settings are not MECE, I set it thay way on purpose. My question is, based on the current setting, the value 4 is between 33% and 34%. In the case where 10 is the maximum, this interval corresponds to 3.3 and 3.4. so We can conclude that 3.3<=4<3.4 which is obviously wrong
Hi ryan-gao
Do you use the the last version?
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2019-feature-summary/#percentRules
Could you show me your original data?
Is the "c2" repeated for the same category in "c1"?
Best Regards
MaggieCommunity 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.
