Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago
Solved

Conditional formatting in table with percentages

Good, I've been trying to apply conditional formatting to a column in a table that has percentages. Basically what I wanted to do was place red if the percentage was between 0 and 10, yellow between ...
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Syndicate_Admin ,

     

    In your case, you need to use measure instead of column field to set color rules. If you use the column , there is no percent options in summarization. 

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Syndicate_Admin , 1. Use number/ absolute value, In place of percent in the conditional formatting screen.

2. If it is % because you mark it % column. It means value is in the range of 0 to 1 and power bi showing it multiply by 100

3. 0 to 10 mean 0 to .1 and so on

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    5 years ago

    Good morning, thanks for the answer. I tried that method and others but it doesn't work for me:

    nsalvay_1-1621620371143.png

    I'm left if it's not an application error.

    Best regards

    Nico

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Syndicate_Admin ,

       

      In your case, you need to use measure instead of column field to set color rules. If you use the column , there is no percent options in summarization. 

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

      Best Regards,

      Dedmon Dai

      • Syndicate_Admin's avatar
        Syndicate_Admin
        Icon for Administrator rankAdministrator
        5 years ago

        Thank you, I wanted to get that doubt out, it would be nice if the tool allowed it without having to resort to a measure. Best regards