Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Example :
I have three dropdown slicers titled as :
1)Region , 2) Country , 3) City
When user select "Asia" from 1st dropdown(Region) then dynamically only related options (Countries in Asia) should be shown in 2nd slicer(Country) as
India
China
Japan
Nepal
and When user select one of the option as "India" in 2nd dropdown(Country) then dynamically only related options (Cities in India ) should be shown in 3rd slicer as city names
Delhi
Mumbai
Hyderabad
Chennai
Please advise me in this concern using DAX.
Solved! Go to Solution.
Hi @dharish20240911 ,
Have you try creating it in Power BI?
Based on description, you don't need any DAX.
This is normal (standard) behaviour of visuals in Power BI.
Just create 3 slicers.
1. slicer = column Region
2. slicer = column country
3. slicer = column city
Once you select value in 1. slicer, it will automatically filter out 2. and 3. slicer (it will only show relevant data).
In Power BI more work is expected to disable interaction between visuals 😉
Cheers,
Nemanja Andic
Put all the data in a single table. When a user selects a region, that will then limit the rows that show up to populate the country list. When they select a country that will limit the rows that show up in the city list.
Put all the data in a single table. When a user selects a region, that will then limit the rows that show up to populate the country list. When they select a country that will limit the rows that show up in the city list.
Hi @dharish20240911 ,
Have you try creating it in Power BI?
Based on description, you don't need any DAX.
This is normal (standard) behaviour of visuals in Power BI.
Just create 3 slicers.
1. slicer = column Region
2. slicer = column country
3. slicer = column city
Once you select value in 1. slicer, it will automatically filter out 2. and 3. slicer (it will only show relevant data).
In Power BI more work is expected to disable interaction between visuals 😉
Cheers,
Nemanja Andic
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
55 | |
54 | |
38 | |
29 |
User | Count |
---|---|
78 | |
62 | |
45 | |
40 | |
40 |