Forum Discussion
date slicers default value
Hi,
I have date ranges from 2003-2020. When users first open the report the slicer should be 31/07/2010-31/07/2020 (as shows below), but all the previous dates are still available and they can manually go to previous years.
Is this possible?
5 Replies
Anonymous
Before you publish the PBIX file to the Power BI Service, Select the preferred date range, in your case July and publish.
If your dates are not adjusted by filters in the date column automatically based on any dynamic measure, this should work.
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
Hi,
Thanks Fowmy
When the report runs for next month, my end date will change to 31/08, will the slicer then automatically change the from and to date to 31/08/2015 - 31/08/2020?
Anonymous , you should save the page with those values. It should work.
- Hi, Thanks amitchandak. In September my end date will change to 31/08, will the slicer then automatically change the from date to 31/08/2015 - 31/08/2020?
