Forum Discussion
Conditional formatting in tables
Hi everyone,
In my report, I have a matrix with an overview of 12 employees. In this Matrix, the employees can see how many sales they made, their budget and "% on budget". In the column with "% on Budget", I want to add conditional formatting with font color formatted by rules. If they have % on budget from 0% to 40% then the font color should be red, if it is from 41% to 70% then yellow and 71% and above then green.
This is quite easy to implement, but the problem is some of the employees have sold more than their budget, which means that they are over 100%. And the percent rules are based on the difference between the lowest and the highest value. So when an employee has a % on budget on 160% then an employee with 64% can have a red color, but the employee should have a yellow color. This isn't optimal. See the screens below 🙂
Hope someone can help 🙂
Hi Anonymous ,
It may be a easy problem, you need to uniform number type.
7 Replies
Hi Anonymous ,
I used "Number" instead of "Percentage" for the conditional formatting options and that seems to work for me.Hope this helps 🙂
ammcleod Anonymous
It still doesn't work for me even though I change it to numbers. I have formatted the number as a percentage and that is probably the reason (see the screen below).do not format it it to percentage and try.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
Hi Anonymous ,
It may be a easy problem, you need to uniform number type.
Hello Anonymous ,
Please vote on this issue: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39300490-fix-percentage-conditional-formatting-in-the-table
I do agree that using numbers instead of percentages resolves the issue but I think that it should be fixed if percentage is going to continue to be an available option.
Sara
