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
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