Default Date selection as current date at Slicer

[Andy123]

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

[Rfingerhut]

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.

[Andy123]

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

[Rfingerhut]

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]

@amitchandak @GuyInACube @DataCube can u help?