Forum Discussion
Slicer stopped working with between style
- 10 months ago
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
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
- Mauro8910 months ago
Super User
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!