Filtering 2nd dropdown slicer by choosing options in 1st slicers

[dharish20240911]

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.

[nandic · Accepted 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

[jdbuchanan71 · Accepted solution]

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.

[nandic · Accepted 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