Conditional Formatting not working on some calculated columns!

[DeeBali]

Hello Fabric Community!

I need assistance fixing conditional formatting on one of the calculated columns in my table. I have a table (screenshot atached) with calculated columns Reported %, Failure % and Ignored %. I have created conditional formatting on the Reported % with no issues. However, for the Failure % column, when I am trying to create the coniditionla formatting on the cell background, it is only working partially. 

From 0-1% the conditional color works fine, but from 1% onwards, the system is only taking the conditionla color that I set for the last percentage. For example, it is not using the color I set for 1-2% but rather it is showing color I set for 4-5% range for all rows after 0%. Please take a look at screen shots attacked and provide some guidance. Thank you. 

[amitchandak · Accepted solution]

@DeeBali , Even if your column is %, you should use "number" and value between 0 and 1. Because % here means allocation

So it will like

0 Number to .10 Number

and so on

Power BI why Rule Based conditional formatting do not work with percent column: Power BI why Rule Based conditional formatting do not work with percent column

[DeeBali]

Thnak you Amit. Using 0.01 instead of 1 for percent worked perfect!