Click-Swapping Drill-Down Maps in Tableau (State → City)

(Tableau 2023.1+ • Sample – Superstore)

Learn how to build a Dynamic Zone Visibility drill-down in Tableau that lets users Ctrl-click multiple states, instantly reveal a city-level map, and click once to swap back to the U.S. overview—no sheet tabs, only a Boolean parameter and two change-parameter actions required.

Create Parameters and Calcs for DZV

1. Create Parameter

2. DZV Calc to Show State Map
   

1. DZV Calc to Show City Map
   

Sheet 1 – “US Profit by State” (unchanged)

1. Longitude (generated) → Columns
2. Latitude (generated) → Rows → mark type Map
3. State → Detail | Profit (SUM) → Color (diverging centred 0)
4. Calc: Show Detail Flag (TRUE) → Detail

Sheet 2 – “Cities in Selected States”

1. Longitude (generated) → Columns
2. Latitude (generated) → Rows → mark type Circle
3. City → Detail | State → Detail
4. Profit (SUM) → Color (synchronise palette with Sheet 1)
5. State → Filters (keep All – listens to the action)
6. Calc: Back to Map (FALSE) → Detail

Dashboard Steps

1. Drop both sheets into one Vertical container.
2. Dynamic Zone Visibility

• Control State Map Visibility Using DZV State
  

• Control City Map Visibility Using DZV Detail
  

1. Filter Action: State-map → City-map (field = State, Run = Select, Clearing = Show all values).

1. Change-Parameter - Go to Detail:
   

1. Change-Parameter - Return to State Level:
   

Using It

1. Ctrl-click or lasso multiple states → DZV flips to a city-level map filtered to those states.
2. Click any city on the city map → instantly back to the U.S. view.