Forum Discussion
Setting Default Slicer Values in Power BI
Hello Power BI Community,
I am working on a report where cascading filters play a crucial role. My report structure is such that the selection in one slicer dictates the options available in the subsequent slicer.
Here's my scenario:
1. I have a **period** slicer where users select a month, year, week...
2. Based on the selected period, a second slicer populates with specific months (e.g., if month is chosen, the second slicer may offer Feb, Aug, and Dec).
3. For this second slicer, I want February (or first offered month) to be selected by default unless the user manually chooses a different month.
4. Further, based on the selection in the second slicer, a third slicer will display holiday names related to the chosen months.
While I've managed to set up the cascading slicers, my main challenge is setting a default value for the second slicer. Is it possible to directly set default slicer values in Power BI? Any guidance or workarounds would be highly appreciated.
Thank you in advance!
- Anonymous2 years ago
Hi Benoo876 ,
Current slicer does not support setting default values. Perhaps you can try to create a bookmark to save the filter effects and bind it to a button actions, then you can simply use it to restore the selections as default value.
Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Docs
Create buttons in Power BI reports - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- CoreyPSolution Sage
I don't believe you can set up default slicer selections. However, based on your description, it sounds like these are hierachical. Have you tried putting all the fields in the same slicer? Something like this might be useful to accomplish what you're after:
- AnonymousNot applicable
Hi Benoo876 ,
Current slicer does not support setting default values. Perhaps you can try to create a bookmark to save the filter effects and bind it to a button actions, then you can simply use it to restore the selections as default value.
Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Docs
Create buttons in Power BI reports - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.