Forum Discussion
Date Between Slicer conditional formatting does not honor background color supplied by Measure
Hi BIDanny ,
Thank you for reaching out to the Microsoft Community Forum.
The slicer visual especially the slider variant (Between) doesn’t currently allow conditional formatting via DAX measures. It does not expose background formatting settings that can be driven dynamically like cards, tables, or matrices.
Please try below options.
Option 1: Overlay a Color Indicator Box
Use a shape (e.g rectangle) behind or near the slicer and conditionally format its fill color using your [Background Color] measure.
You can insert a rectangle. Bind its background fill color using the [Background Color] measure. Add a tooltip or label to say: “Click here to reset filters”.Option 2: Show a Warning/Reset Button
Create a button or text label like: “Filtered View – Click to Reset”. Then use a bookmark to reset filters. Show/hide this based on [Is Filtered Date].
Option 3: Use Chiclet Slicer or Custom Visuals
Explore slicer alternatives from AppSource like Chiclet Slicer and Hierarchy Slicer Some custom visuals allow better conditional formatting and styling, though slider support may still be limited.
If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.
Thank you
Hi BIDanny ,
You're correct that conditional formatting does not work on the "Between" date slicer in Power BI. Even though your measure is perfectly valid, the slicer visual simply ignores background color settings when it's in slider mode. The measure you wrote:
Background Color =
IF(
[Is Filtered Date],
"#42a247",
"#FFFFFF"
)
combined with:
Is Filtered Date = ISFILTERED('Table'[Date])
works fine on other visuals like card or table, but not on the Between-style slicer. The slicer doesn't honor conditional formatting for either font or background color, which appears to be a limitation of the visual rather than a bug in your DAX. If you want to signal to users that the slicer is active, your best workaround is to place a shape or card nearby and dynamically change its color using your measure. You can also consider using a text box that appears conditionally or use a different slicer visual like Smart Filter Pro or Chiclet Slicer for more control. Unfortunately, for now, Power BI doesn't provide native support for dynamic formatting on the slider-based date slicer.
Best regards,
While your reply is appreciated, I've already used Copilot prior to coming here. I think as a community we should do better then just farm replys and likes, and keep the conversation going the right direction. There is way too much AI generated content online as it is.