Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
Anonymous
Not applicable

Dynamic Date Slicer where earliest defaults to today and latest defaults to 6 days (week) later

We work on lengthy projects and I have a report showing scheduled hours by project and person from now into the future. Users are mainly interested in what they're doing within the next week. How can I make the Dates Between slicer dynamic so when a user opens the report (in service) the earliest date on the slicer will reflect today and the latest in 6 days? This will keep rolling as the days go by. This would be a default setting as users might still want to change the date range to a day, or month etc. Thanks for any advice.

1 ACCEPTED SOLUTION
AllisonKennedy
Super User
Super User

@Anonymous  You could add a page or report level filter for relative date. The two slicers will work together. 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as 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 C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

2 REPLIES 2
AllisonKennedy
Super User
Super User

@Anonymous  You could add a page or report level filter for relative date. The two slicers will work together. 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as 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 C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Anonymous
Not applicable

Thanks Allison. The issue I had with this solution was that I could no longer change the dates before or beyond the week in the original dates between slicer. Anyway I decided not to complicate the report and replaced between with relative date. Thanks for the quick response.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.