Forum Discussion
DeeBali
2 years agoHelper I
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 %, Failu...
- 2 years ago
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
amitchandak
2 years agoSuper User
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
2 years agoHelper I
Thnak you Amit. Using 0.01 instead of 1 for percent worked perfect!