Forum Discussion

CalvinL's avatar
CalvinL
Helper II
6 years ago
Solved

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.

2 Replies

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

  • AllisonKennedy's avatar
    AllisonKennedy
    Community 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. 

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