Slicer stopped working with between style

[roger-allen]

Hi

I am using the latest Version: 2.149.1203.0 64-bit (November 2025) of Power BI desktop on WIndows 11

I have a time slicer for a direct query against sql on a date column, if I change slicer style to 'tile', it works just fine (shows last 60 days)

If I change it to 'between', 'before' or 'after' then it just shows blank values

How do I get it to work with 'between'?

Roger

[roger-allen · Accepted solution]

ok, I beleive I have managed to fix it myself, but it does appear to be a bug, so I'll explain it here in case it helps others

This is the direct query I use, the slicer is on event_time_rounded, but as you can see the query also has a predicate on waitstartdate and waitenddate, which are parameters

You can see that the default values for theses parameters are more than 60 days ago i.e 01/10/2025 and 10/10/2025 and because I keep a rolling 60 days of data, those values will filter out all rows.

However on the page itself, I have more recent dates linked to these parameters

But the silcer with 'between' seems to ignore these and instead validates on the default values i.e. it expects no rows

But the rows are there.  You can see them If I change the slicer from 'between' to 'dropdown', it just doesn't show them when using 'between' 

So the fix is the change the default values to something that does return rows

and then the slicer displays correctly with 'between'

Wierd bug

Roger

[v-tejrama]

Hi @roger-allen ,

Thanks for reaching out to the Microsoft fabric community forum.

The issue you're experiencing is due to a known limitation in Power BI when using DirectQuery with date slicers set to Between, Before, or After. These slicer options require Power BI to find the minimum and maximum dates at query time, but in some DirectQuery cases, it can't always resolve those values because of how queries are processed or how the data source applies filters.

As a result, the slicer may appear blank, even though the same field works in Tile or List mode. This isn't caused by the column data type, page or visual filters, or a problem with the report itself. It's also why you can't fully reproduce this in Import mode with DAX, since Import mode always knows the full date range. For a reliable solution, consider using a relative date slicer or importing a calendar table for date filtering.

Best Regards,
Tejaswi.
Community Support

[roger-allen]

I don't think you can view a visual in TMDL view, thats only for viewing data models

Something else I have tried is copying all the visuals on to a blank page, but that didn't make any difference. Likewise creating a new slicer doesn't make any difference. It is still a mystery

[Mauro89]

@roger-allen did you check if there are visual filters applied?

Do you have any other date column which you can try out? 
Or create a new column with data type date and try if this works?

[Tahreem24]

@roger-allen Like you mentioned this between slicer works well with other pages. Did you try checking the page level filters applied if any on your page as compare to other pages where it works fine?

[roger-allen]

Hi

I have tried both date and datetime in the direct query, I get the issue with both

I suspect this might be a bug as other pages do not have the issue and it used to partly work where the dates would show, but the slider was greyed out, but now the dates are now blank too

Roger

[Mauro89]

Ok wait, is the same slicer working on another page? Then I assume nothing is wrong with data rather then the page or visual setup.

Have you compared the visual definition like in the TMDL view?

Best regards!

[Mauro89]

Hi @roger-allen,

have you checked your data type of the corresponding column?

Ensure it is of type "Date" as maybe "DateTime" cause issues.

Best regards!

PS: if you find this helpful, leave kudos or mark as solution.