Forum Discussion
CalvinL
6 years agoHelper II
Limit Slicer Options
Hi all,
I have a slicer for a date range from 2017-2020. I want to limit it to dates in the last 7 days.. how do I do this?
Thank you.
Put the date into visual or page level and filter for last 7 days.
2 Replies
- amitchandakSuper User
Put the date into visual or page level and filter for last 7 days.
- AllisonKennedyCommunity Champion
You can do relative date filtering as either a visual level filter or change the slicer type to relative by clicking the arrow in the heading of the slicer.
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.