Wants to set default current week and previous week in slicer

[shilpa123]

Hi 

I have a requirement like by default in slicer it should select current week and previous week in the slicer  can any one please help me out with this requirement.

Thanks

[v-shex-msft · Accepted solution]

HI @shilpa123,

The current slicer does not support setting default values, you can create a calculated column to check row values based on current DateTime and return flags.

After these steps, you can manually select the flags and save them to bookmark, then you can bind this bookmark to the button action and use it to reset the default selection. (notice: this calculate column will be dynamic change based on current system DateTime)

Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Docs
Regards,

Xiaoxin Sheng

[kapinal]

Hi, If you have any requirement like by default in slicer. you can contact Dynamics Square. Dynamics Square is a Microsoft Partner. You can contact directly