Forum Discussion

vkal12's avatar
vkal12
New Member
4 years ago
Solved

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...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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's avatar
    v-jingzhang
    4 years ago

    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

vkal12's avatar
vkal12
New Member
4 years ago

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's avatar
v-jingzhang
Community Support
4 years ago

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