Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Fixed Time Periods in Slicer

I am currently using a slicer on one of my reports to change the date range of the dataset - what I would like to do is have a selection of buttons of predefined date periods: e.g. a 1 month button for the last 30 days, a 3 month button for the last 180 days etc

 

It is worth noting that I have a number of other filters on the page, so using a bookmark wouldn't work as it would have to reset the other filters.

 

I also considered creating a calculated column defining whether the start date was in one of the above periods - again this would cause an issue as being in the '3 month' category would exclude it from the '1 month' category.

 

I appreciate any help anyone can give me!

2 Replies