Forum Discussion

Bt123's avatar
Bt123
New Member
9 years ago

Conditional Formatting on Percentages

Is there any way to apply conditional formatting on percentages in a table?

6 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    9 years ago

    Can you elaborate little more what you mean by conditional formatting?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Bt123,

     

    >>Is there any way to apply conditional formatting on percentages in a table?


    Current power bi conditional format feature not support text, you can calculate the result as decimal, then switch the display mode(percent) at modding panel.

     

    Regards,

    Xiaoxin Sheng

    • rlien1's avatar
      rlien1
      Frequent Visitor
      9 years ago

      Power BI handles percentages as text?  I'm confused.

       

      If I want to apply a conditional format to all values above 85%, I try entering 0.85 or 85 or 85% in the conditional formatting input fields.  Power BI unfortunately applies the formatting to all values in the table, including those less than 85%.

       

      My percentage is a result of a quick calc (% of column total).

      • aslee's avatar
        aslee
        Icon for Helper I rankHelper I
        9 years ago

        Has anyone found a solution to this? I am having trouble with this too. 

    • Nathaniel_C's avatar
      Nathaniel_C
      Icon for Community Champion rankCommunity Champion
      6 years ago

       

       

      Hi KH11NDR , Bt123 , aslee , rlien1 , Anonymous 
      See my top picture, save your rule as decimals, and use number.  I forget why this works this way, but there is a reason.  Something to do with percentage meaning a percentage of all your values.
      Let me know if you have any questions.

      If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 

       

      are nice too.
      Nathaniel