Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

How to set Default Slicer Values based on other slicer selections

I want to understand how to setup default slicer values. 

For Ex. I have two slicers States and Cities.  assume i save the default selection for both slicers to California and Las Vegas.

I have turned off interaction from Cityr Slicer-> State. Only State Slicer should filter City Slicer. 

Now the problem is when user changes State Slicer ex. from "California" -> "Texas".  The previous selection on "Las Vegas" in city slicer still persists and visuals are showing blank.  User now has to make change the previous selection on City Slicer from "Las Vegas" to something else like "Houston" for the visuals load. 

How can we dynamically change the default selection on City Slicer when an element is changed on "State Slicer"

2 REPLIES 2
Idrissshatila
Super User
Super User

Hello @Anonymous ,

 

It won't work like this because you turned off the interaction between them.

 

What you could do is put them both in one slicer as a hierarchy and they can show under each others, every state with its cities.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Anonymous
Not applicable

The problem is, both slicers have to single select based on the data model. With hierarchial slicer if i have 3 levels State, City, Zipcode and then select a particular city it selects all zipcodes by default.  The single select in hierarchial slicer by default only works at the highest level (State)

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.