Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi there, I have a data set with a date range between July 2012 and today (I'm daily refreshing the data set).
I want my users to have a date slicer that shows the full date range (2012 - today) but the default start date should be on the 1st of May 2019 and the default end date should be the newest available data.
Hi @Anonymous ,
1. In Power BI Desktop, set the value of the slicer to the value you want and publish the report to Service.
2. In Power BI Service, the slicer value is now the default value. After you adjust the slicer, you can use the "Reset to default" button to restore the settings.
About refresh:
As tested, Even if the date is refreshed daily, the date range on the slicer always stays (5/1 / 2019-today).
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Refer, if this can help
https://community.powerbi.com/t5/Desktop/Set-TODAY-as-default-date-in-slicer-visual/td-p/488670
One way is to restrict the calendar to today.
Hi amitchandak, thanks for your reply!
I've already seen the second and third link and they don't solve my problem.
The first link refers to a JavaScript solution in case I'd want to embedd my report which is not the case here.
Any other hints?
Hi,
I have a same business requirement, set default dates in date slicer range, I use the way below your post, but the user say still not default date range in his side, I am wondering if you solve this question, how to solve it, thanks .
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
75 | |
68 | |
41 | |
35 |
User | Count |
---|---|
102 | |
56 | |
52 | |
46 | |
40 |