Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conditional Formatting Percentage Issue

Hello,

 

I am having an issue with conditonal formatting on one of my measures. I have formatted the value to percentage and the decimal to two places. It is conditional formatting everything as red. I would like any value over 3.5% to be formatted in red.

 

Thank you!

 

Need Help
  • FrankAT's avatar
    FrankAT
    6 years ago

    Hi Anonymous ,

    take this solution and customize it:

     

     

    Regards FrankAT

6 Replies

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

    Anonymous replace 3.5 to .35, it is a decimal value not a full number and 100 to 1

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      parry2k thanks for the information. When I did that it is showing no conditional formatting.

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

    Hi Anonymous ,

    you have change it like this:

     

     Regards FrankAT

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      FrankAT I tried that as well and it is showing like this:

      • javeir_obregon's avatar
        javeir_obregon
        Frequent Visitor
        6 years ago

        Can you upload the image from your conditional formatting window?