I have a huge dashboard that has several pivot charts, slicers etc. The slicers I have are Week number and Month. To set this up I actually have a date column in my data, but also a week number column which I have the week number using WEEKNUM.
So when looking at the slicer for weeks it just has weeks 1 - 53 which the end user doesn't necessarily know which dates those are for. I didn't wan the slicers to actually have the date range on them because it is sloppy (although I may have to go that route)
But I was wonder if when I click say Week 1 if I could then have a cell that shows the "currently viewable date range" so like when I click Week 1 it would say "01/01/2021 - 01/02/2021" (since week one is just those two days)
Any ideas?
I've gone back and forth on this stupid thing. First I didn't have a weeknum column but was just using date grouping but it caused other issues with getting weekly data and monthly data so I went this route.
I guess I could just rename the week numbers to date ranges but then my slicer is just sloppery to look at.
Bookmarks