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

v-jingzhang's avatar
v-jingzhang
Community Support
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.

 

  • 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