Forum Discussion

lahani04's avatar
lahani04
Frequent Visitor
11 months ago
Solved

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

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...
  • v-nmadadi-msft's avatar
    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