Forum Discussion
Solved
Conditional Formatting not applying as expected when using Percentages
I have a matrix, it has Business Names as Row headers and a Status as Column Headings I cound the status per business like this and you can see that some have the same value in Full as in Total ...
It's quite a common misunderstanding this one. You can search the forum for solved similar issues.
Using 'percent' in conditional formatting is not about the data type, it's about
"the rule boundaries as a percent of the overall range of values" which you don't want in this case.
Use a different rule type as here:
I dont know who accepted the solution, but it did not provide a solution to my problem, it just told me that I was wrong and had misunderstood what PowerBi did. none of the examples at the listed URL come close to the use case I demonstarted here.
This is an abuse of the accepted solution system IMO.