Forum Discussion
Auto-select a slicer value based on another slicer's selection (button-style slicers)
Hello 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.