Problems with conditional formatting on percentage values

[vkal12]

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!

[v-jingzhang · Accepted solution]

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.

[v-jingzhang · Accepted solution]

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.

[vkal12]

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

[v-jingzhang · Accepted solution]

@vkal12 

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

[lbendlin]

Change "Summe von A"  to "Durchschnitt von A"

[vkal12]

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

[Syndicate_Admin]

But when the result is 0.00% how do you use conditional formatting?