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 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

Need Help

4 Replies

  • 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.