Limit Slicer Options

[CalvinL]

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.

[amitchandak · Accepted solution]

Put the date into visual or page level and filter for last 7 days.

[AllisonKennedy]

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. 

https://sites.google.com/site/allisonkennedycv