Forum Discussion
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 Po...
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.
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 - 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.