Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
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