Conditional Background Color Not Working Properly After Applying Slicer in Power BI

[lahani04]

Hi everyone,

I’m using conditional formatting to set the background color of a column based on a condition in Power BI Desktop. It works perfectly when no slicer is applied.

However, when I apply a slicer or filter for certain groups, the background color doesn’t display correctly for some rows.

Has anyone faced this issue? Is there a way to make the conditional formatting work properly even after applying slicers or filters?

Any guidance would be appreciated!
Condition:

Not Working properlly with Filter:

Without filter:

[v-nmadadi-msft]

Hi @lahani04 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[v-nmadadi-msft]

Hi @lahani04 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @lahani04 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft · Accepted solution]

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

[Shahid12523]

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.