Forum Discussion
Custom Date Table slicer causing data to vanish
Community ChampionRight, I see some of what's going on now. The slicers are affecting each other because they are probably in the same table and that's causing no data to be returned in the main table visual. You can investigate this by hovering the cursor over the funnel icon in each visual. That tells you what is filtering the specific visual.
If you are introducing a date dimension in the model then you'll want to use that in the slicer. I still don't like the model but that's the first problem to solve.
Hi,
There's three slicers built-in currently, Client Reporting Group, Instruction Type and Discipline. Client Reporting Group and Instruction Type both come from Incident and Discipline comes from Account, however none of them have had values selected for filtering when testing with Date, and I've tried removing them and only using the Date filter to get the same result.
Without any options selected on the slicers, there's no filters applied to the table but the other slicers work as I would expect them to, though I did have to make another relationship active as you'd suggested. I can slice down with both incident and account to filter our data down, but adding date into the mix breaks the system: