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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Set default dates in date slicer range

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.

4 REPLIES 4
v-lionel-msft
Community Support
Community Support

Hi @Anonymous ,

 

1. In Power BI Desktop, set the value of the slicer to the value you want and publish the report to Service.

aaa1.PNG

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.

aaa2.PNG

 

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.

Anonymous
Not applicable

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 . 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.