Forum Discussion
Date Slicer NOT filtering correctly ?
I've got 3 slicers, 2 behave correctly, but a Year slicer I have works fine when set to ALL, but will not filter my GROUP SWITCH when Years are selected ? (see image)
How do I get the GROUP to recalc based on whats also selected in YEAR ?
Thx
8 Replies
if this helps .. pretty simple data model
Sample Workbook Sample Workbook
Here's what I was expecting (2 AVGs > 100)
Can you get to this ?
Sample WorkbookBumping this thread as still cannot get this to work?
When set to YEAR = ALL the group counts are accurate,
But changing to 2021, they are not accurate
