Conditional formatting issue on percentage

[Anonymous]

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?

[Anonymous]

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).

[ceebu]

@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.

[Anonymous]

@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]

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.

[Anonymous]

@ceebu it seems not to affect the value of 0,99%... Even if I set only one rule, it is untouched by it. But it is greater than 0 and less than 1...

@Anonymous yes this is the calculated measure, and the units are set to auto

[Anonymous]

Hi @Anonymous ,

Would you Please like to check the Value decimal places for Data labels under format section.
Make the Value deimla places as 2 and give a try.

It's about precision 

[Anonymous · Accepted solution]

@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.