Forum Discussion
Conditional Background Color Not Working Properly After Applying Slicer in Power BI
- 11 months ago
Hi lahani04 ,
Thanks for reaching out to the Microsoft fabric community forum.
Generally Conditional formatting should respect Slicer/filter settings. Please try this and re check the functionality, 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%. When you select Percent in conditional format dropdown, you’re setting the rule boundaries as a percent of the overall range of values from minimum to maximum. So, it's actually mean Percentile.
Source: Apply Conditional Table Formatting in Power BI - Power BI | Microsoft Learn
I hope this information helps. Please do let us know if you have any further queries.
Thank you
Issue happens because slicers change context → your rules break on blanks or recalculated values.
✅ Fix:
Use the same SLA % measure for formatting (not a column).
Handle blanks with IF(ISBLANK([SLA %]), -1, [SLA %]).
Best fix → create a color measure returning hex codes, then use Field value in conditional formatting.