Forum Discussion
CatLowe
2 years agoNew Member
Custom Date Table slicer causing data to vanish
Hi, I've been building a report for a client and we need to create a central Calendar table which we can use for filtering purposes and for calculations. I've read up about this online and the pr...
HotChilli
Community Champion
2 years agoThe pictures just posted seem to show that there is no data (fields and measures in the table visual) that meets the filters applied on the visual. I'm especially looking at the date filter between 16/02/2015 and 24/01/2023
What are you expecting to see?
- CatLowe2 years agoNew Member
Apologies, I made a mistake with the previous screengrab, however with the updated one we see date is between 13/02/2018 and 26/02/2024, and three records with a Created On of 02/01/2024 have been removed when I'd expect them to remain:
Oddly if I only modify the higher date then they remain. As soon as the lower date is changed, the records vanish: