Forum Discussion

Manish1198's avatar
Manish1198
Helper I
1 year ago
Solved

Dynamic default slicer

Hi community,  I have two use cases to set default value in the slicer without external visual Preselected slicer (if possible). Case 1: Set the default value to least open month (Mar-25 in the fol...
Need Help
Tips and Tricks
  • v-sathmakuri's avatar
    v-sathmakuri
    1 year ago

    Hi Manish1198 ,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    By default, Power BI does not support programmatically setting a default selection in slicers.

     

    However, you can achieve a dynamic slicer experience using bookmarks. I have attached a sample .pbix file by using this approach. After publishing the report to the Power BI Service, the default view will appear as intended. If users wish to access a version of the report with the full slicer for multiple selections, they can do so by clicking the provided navigation buttons.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thank you!!

Manish1198's avatar
Manish1198
Helper I
1 year ago

Thanks for the input burakkaragoz 
But, this would remove the ability to select months other than the default. The user should be able to select other month as well. 
The 2 cases Least Open Month and Most Recent Closed Month are for two different reports. So, the logic for any one of these would suffice, as i can replicate for the other. 

This will really help me: The slicer should be set to least open month when the user opens the report. And the user should be able to select other months from the slicer dropdown.