Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Red for negative

Hi,

 

I have percetage variable, how to change negative number in red.  In Value I am unable to see Conditional format. please HELP

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Where are you checking? Some time when you hover over background color or font color you will see three dot and there you have the option

     

    Appreciate your Kudos.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Where are you checking? Some time when you hover over background color or font color you will see three dot and there you have the option

     

    Appreciate your Kudos.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I have value in card 

       

                                 curr yr sales

              

                 prev yr sales                curr yr sales / prev yr sales ( this is in percentage) here i want negative value in reg

      • v-xuding-msft's avatar
        v-xuding-msft
        Community Support
        6 years ago

        Hi Anonymous ,

        Please try like this:

        Measure = IF([Percentage]<0,"Red")

         

        Best Regards,

        Xue Ding

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