Forum Discussion
Auto-select a slicer value based on another slicer's selection (button-style slicers)
Hi all,
I have two button-style slicers on my report page:
- Year slicer: 2025 / 2026 (single-select)
- Quarter slicer: Q1 / Q2 / Q3 / Q4 (single-select)
The Quarter slicer already cross-filters correctly based on the Year selection — for example, when I select 2026, only Q1 shows up as an available option (since that's the only quarter with data so far for 2026). When I select 2025, all four quarters (Q1–Q4) are available, as expected.
The problem: when a user switches the Year slicer to 2026, Q1 becomes the only available button, but it is not automatically selected/highlighted. The user still has to manually click Q1 every time they switch to 2026.
What I want: when Year = 2026 is selected, I want the Quarter slicer to automatically select Q1 by default — without requiring a manual click.
4 Replies
Hi AlonCarmel,
As per your requirement, Cross-filtering should be enabled for both Year and Quarter. Click on Quarter Slicer > Format Tab > Enable "Edit Interactions" > Select "Filter" on Year Slicer. This will enable to cross-filter both the slicers.
Result - Year 2026 Selection makes Quarter 1 selected.
💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster
Best regards,
Rupasree Achari | BI & Fabric Analytics EngineerHello AlonCarmel,
Short answer: no, native Power BI slicers can't do this. They can filter each other's available values just fine that part's built in. So when you pick 2026, the Quarter slicer correctly narrows down to just Q1.
But Power BI stops there. It won't take the next step and actually click that Q1 button for you. The user still has to do that manually, even though it's the only option left.
If you want that auto-select behavior, you're looking at workarounds rather than a built-in setting:
1. Bookmarks set up a bookmark for each Year/Quarter combo you care about and trigger it with a button.
2. A combined Year-Quarter slicer, instead of two separate slicers, use one field like "2026 Q1" so there's nothing to keep in sync.
3. DAX defaults write your measures to fall back to a default quarter when nothing's selected. This fixes what the visuals show, but the slicer itself still won't look selected.
Bottom line: there's no native setting that picks the last remaining value in a slicer once another slicer has filtered it down. You'll need one of the workarounds above.No, this isn't possible with native Power BI slicers. They can filter available values but can't automatically select the only remaining option. Your best alternatives are bookmarks, a custom slicer visual, or handling the default in DAX.
