Forum Discussion

Benoo876's avatar
Benoo876
Advocate I
2 years ago
Solved

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!

2 Replies