Forum Discussion

Andy123's avatar
Andy123
New Member
3 years ago

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...
Need Help
Rfingerhut's avatar
Rfingerhut
Frequent Visitor
3 years ago

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's avatar
Andy123
New Member
3 years ago

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's avatar
    Rfingerhut
    Frequent Visitor
    3 years ago

    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.