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

v-sathmakuri's avatar
v-sathmakuri
Community Support
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!!