Forum Discussion
Date Between Slicer conditional formatting does not honor background color supplied by Measure
- 1 year ago
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 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Thank you.
Hi @BIDanny ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Thank you.