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

[BIDanny]

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 touch it, so they know they need to clear the selection to get back to the full dataset again.

You have a Date in your table

Table = calendar("1/1/2025","5/1/2025")​

Create a couple measures

Background Color = 
IF(
    [Is Filtered Date],
    "#42a247",  
    "#FFFFFF"   
)

Is Filtered Date = isfiltered('Table'[Date])

Layout visuals

Apply filter, and the vertical list works great however the Slider ignores the provided color setting from the measure.

Ill find another way I suppose, but would be 🍌🍌🍌🍌🍌🍌 to get a "New" Slicer visual that provides sliders like the old one.  I use them a lot, actually 🙂

[v-dineshya · Accepted solution]

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

[v-dineshya]

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.

[v-dineshya]

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.

[v-dineshya]

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.

[DataNinja777]

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,

[BIDanny]

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.