Forum Discussion
ryan-gao
Helper III
Helper IIICalculation logic behind percent conditional formatting
Hi Guys I use a very simple sample data to demonstrate the results of the percentage conditional format. Please explain the calculation logic. The table has only four rows,take 10 as the...
ryan-gaoHelper III
Helper IIIThanks 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
v-juanli-msft
Community Support
Community SupportHi 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
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.