Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Conditional formatting issue on percentage

Hello,

I have a problem with conditional formatting. It is set up as on the picture below, but the 0.99% value on a chart is green and it should be red. Am I doing something wrong or this is some PowerBI error?

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous ceebu - thanks for all your help. Due to many measures in the report, it was doubled one with the wrong name which I've just replaced and it is OK. PowerBI is working good.

     

    Sorry for the inconvenience.

     

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous ,

     

    Make sure Data type and Format for the value is Decimal Number.

    To See Format, Select the column and go to Formatting section under Modelling tab in Power BI desktop (top banner).


    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Anonymous Data type is decimal. The format is Percentage (as I want it to show %), but even changing it to decimal does not change the color of data to red.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Anonymous ,

         

        Are you calculating this value column, means do you have this metric value as per any calculation?
        If possible check the data labels under format section and change Display units to Auto.

    • ceebu's avatar
      ceebu
      Icon for Advocate I rankAdvocate I
      7 years ago

      Anonymous  - your solution would need the data type to be changed - might not be always possible - 

       

      Anonymous :  Please try using  decimals for your rules -  For eg: 0.9 for 90% and 1 for 100% ? 

       

      See sample below to demonstrate the effect of decimals for percentage formatted values.