Forum Discussion
Conditional Formatting not working on some calculated columns!
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.
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
2 Replies
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
Thnak you Amit. Using 0.01 instead of 1 for percent worked perfect!
