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
Andy123
New Member

Default Date selection as current date at Slicer

I need to publish the report to Service such that the default selection for Year and Quarter at slicer is the current Year and Quarter , I have created slicer using Year Hierarchy which includes Year and Quarter from a disconnected Date table.

Currently it is selecting all quarters of the current year (i.e, 2023) by default at slicer when published 

Expected is to select just Q3 of 2023

4 REPLIES 4
Rfingerhut
Frequent Visitor

Power BI has never really been able to handle dynamic default slicer selections natively.  For your use case, I would recommend introducing some logic in the SQL or M that flags your desired parameters with something like "Current".  Then, you can have "Current" as your saved value in the slicer and the logic in the backend is handling the dynamic component.

Hi @Rfingerhut 

Could u pls elaborate more regarding this solution would be helpful if u can provide SQL or M code or any helpful link for the same

Thanks

One method could be dropping the "Q" from the quarter, or if you have another field that is just quarter number, then add that number to year.  The max value of that column would then be set to "Current" and everything else is just the Quarter - Year value for the slicer.  There may be better ways to handle this, but that's what comes to mind first.

Andy123
New Member

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.

Top Solution Authors
Top Kudoed Authors