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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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

  • vkal12's avatar
    vkal12
    New Member
    4 years ago

    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's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      1 year ago

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