Forum Discussion
Problems with conditional formatting on percentage values
Hello everyone,
I am having troubles with conditional formatting in Power BI. I have a table with three columns: Month (type: date), A (type: percentage), B (type percentage). I have empty values for the column A and B for months, that have not started yet or for which I don't have values yet.
When creating a table in Power BI and trying to do a conditional formatting that shows all the values equal or higher to 95% in green and all the values lower than 95% in red, I'll get the following image.
(Sorry for that it is in german, I hope one can understand it)
I've absolutely no idea, what I am doing wrong but I will never get the correct formatting. I've read through different posts here and tried out there solutions but I cannot find the problem.
Does someone have any kind of idea what I am doing wrong?
Thank you very much!
Hi vkal12
Use Number instead of Percent like below.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.The values in column A are all greater than 95% so the result looks correct, doesn't it? From your screenshot, the rule of green still uses Percent after 0.95, change it into Number and check the result.
BR,
Jing
6 Replies
Hi vkal12
Use Number instead of Percent like below.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.Hi v-jingzhang,
thank you for your hint. I've tried this out and funny enough, it works for the values in column B. But for column A the distribution of colors looks really weird.
How can that be?
Thank you and best regards,
Vanessa
The values in column A are all greater than 95% so the result looks correct, doesn't it? From your screenshot, the rule of green still uses Percent after 0.95, change it into Number and check the result.
BR,
Jing
Change "Summe von A" to "Durchschnitt von A"
Hi Ibendlin,
thank you for your reply. I've tried this out but I did not work. The solution of v-jingzhang worked for 50% of the problem.
Thank you and best regards,
Vanessa
But when the result is 0.00% how do you use conditional formatting?
