Forum Discussion

BIDanny's avatar
BIDanny
Frequent Visitor
1 year ago
Solved

Date Between Slicer conditional formatting does not honor background color supplied by Measure

Hello Fabric Community!  The conditional formatting does not apply when you are using a Between slicer.  I believe this to be a bug.  I just wanted to call attention to the Date Slicer when they touc...
  • v-dineshya's avatar
    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