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
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
- Mauro8910 months ago
Super User
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?