Forum Discussion

imCosmo's avatar
imCosmo
Regular Visitor
5 years ago
Solved

Conditional formatting for percentages

Hi, I'm trying to get conditional formatting for percentages on a card visual within PowerBI.
The rules simply state if a number is above 95.01% > it'll go green etc.

Below is the visual I'm trying to amend, however the red is hard stuck despite stating it should work for values inbetween 0.01% and 94.99%

 

I'm unsure of why this is happening, any advice would be appreciated.

  • Hi imCosmo ,

     

    Percentages are decimal number so you need to set your values to:

    greater 0,9501 - Green

    equal 0,9501 -yellow

    less 0,9501 - red

     

    Has you have it is reading the percentage has: 9501%

1 Reply

  • Hi imCosmo ,

     

    Percentages are decimal number so you need to set your values to:

    greater 0,9501 - Green

    equal 0,9501 -yellow

    less 0,9501 - red

     

    Has you have it is reading the percentage has: 9501%