Forum Discussion
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!
Hi Anonymous,
Does relative date slicer meet your requirement? If not, please provide sample data and show us your desired output.
Best regards,
Yuliana Gu
2 Replies
- v-yulgu-msft
Microsoft Employee
Hi Anonymous,
Does relative date slicer meet your requirement? If not, please provide sample data and show us your desired output.
Best regards,
Yuliana Gu
- Greg_Deckler
Community Champion
You could perhaps use a disconnected slicer table with those categories to do this but would need to understand your data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490