Forum Discussion
RachnaV
Helper I
4 years agoConditional Formatting not working
I have a Matrix visual wherein conditional formatting has been applied on the background. There some filters defined on the report. Conditional formatting is working correct when no filter is appl...
jdbuchanan71
Super User
4 years agoWhen you select Percent in this dropdown, you’re setting the rule boundaries as a percent of the overall range of values from minimum to maximum.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
If the field the formatting is based on contains percentages, write the numbers in the rules as decimals, which are the actual values; for example, ".25" instead of "25". Also, select Number instead of Percent for the number format. For example, "If value is greater than or equal to 0 Number and is less than .25 Number" returns values less than 25%.