Forum Discussion
imCosmo
5 years agoRegular Visitor
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%