Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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.
Solved! Go to Solution.
@Anonymous You could add a page or report level filter for relative date. The two slicers will work together.
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 You could add a page or report level filter for relative date. The two slicers will work together.
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
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
85 | |
70 | |
68 | |
50 | |
32 |
User | Count |
---|---|
117 | |
100 | |
73 | |
65 | |
40 |