SIMPLE Map Drill Down in Tableau with Dynamic Zone Visibility

Creating a drill-down map in Tableau used to be more challenging than it needed to be.
But now, with the dynamic zone visibility, we can create a map drill down in just a couple of simple steps.
By signing up for my newsletter you get:
1. Early access to tutorials
2. New products
3. Discounts
4. Access to my private community on Discord
5. Notifications about any upcoming events and opportunities to learn
and more by joining my newsletter.
Sign up at andykriebel.com.
🆓 DOWNLOAD the data, plus a starter and completed workbooks:
andykriebel.gu...
🥁 See the viz in action:
tabsoft.co/3X0...
===============
LEARN:
📈 Mastering Layout Containers
bit.ly/tableau...
🗞️ Newsletter
andykriebel.com/
===============
CONNECT WITH ME
linktr.ee/andy...
===============
ARE YOU INTERVIEWING FOR A NEW JOB?
Contact me for more information about how I can help you prepare for that big interview.
[e-mail]

[@Trying_trying]

Really helpful videos as I am doing a data analyst boot camp and today was tableau day. great stuff.

[@prasanthbalasubramaniam4492]

Hi Andy, Its a great demo. When I use selection tools in maps(radial, rectangular, lasso) the parameters are set to blank. It works well without touching the selection tools.

[@D.Nichols-x6q]

Thank you for posting. Really incredible, easy to follow walk through. For me, worksheet swapping only worked if it was in a vertical container. After troubleshooting for way too long, this seemed to be my issue.

[@Mohammed-kh4lj]

Great Visualisation Andy, helped me with my work❤

[@vizwiz]

Great to hear!

[@jasiu1818]

I wish you were my teacher in college ! Your tutorials are awesome, thank you :D

[@rsnazario]

Hello Andy! Amazing KZbin Channel! It's been helping me a lot. I have a question for you. In my case-scenario I have the World Map (data per country) that drills down to data per state when I click in some country. I would like this country to appear, when clicked, bigger and in the center of the screen. How can I accomplish that?

[@swetas1519]

thanks for the great video and i am able to implement the same on my dashboard, just 1 doubt when i click on some blank space on the map all the parameter values got blank there's noting on the map, it would be great if you can share the fix for this issue

[@vizwiz]

That shouldn't happen if you follow the steps exactly the same. Maybe you were slightly off at one step.

[@suzyliu7335]

Hey Andy, thank you so much for the video! This 2-level drill down visual works fine on my Tableau Desktop, however, when I publish it to Tableau Public, when I click the postal code and try to go back to state map, the visual splits into two (state and postal code visuals) instead of one (state visuals). I'm wondering if there is any fix to this?

[@BunchheanChhiv]

Hey I got the same issue. Let's me know if you have solved the issue. Thanks

[@BunchheanChhiv]

hey I just solved the problem by creating a new calculation field which is State Selected by giving the value to (State Parameter != ' '). Then on the dashboard just click on the Postal code chart --> click on control visibility using value --> Choose State Selected. It'll work fine.

[@suzyliu7335]

@@BunchheanChhiv Thank you!! I will try it out on my end!

[@CharvikMuddasani]

Hi Andy , Your videos are very much knowledgeable. You have build many dashboards and published into tableau server . Can you please build a dashboard to monitor the health check of each dashboard in tableau server. If it down it should show red color missing values it should show some other color if it is running fine than green like wise .

[@vizwiz]

Search tableau public. There are lots of examples there.

[@JulianaMapper]

Thanks so much! Question for you- is it possible to set this "filtering" based on zoom? So that you don't have to click a state to see the state-level zip code data? I would like to be able to zoom in and see areas that are at the intersection of a few states.

[@vizwiz]

Not that I know of because you wouldn’t be filtering the data, you’d only be zooming.

[@shaiksk907]

Hello Mr. Andy I have a problem with state dimension when I double click on state dimension it's not representing map with doted marks on the states and am not able getting map like in the initial stage it is possible some times When I included country to details in the marks pane but some features are not able to include can you please suggest me where am I wrong in creating viz

[@y.7926]

Thanks!

[@vizwiz]

Thank you so much!!

[@ferdinandusruruk2000]

Hello andy, How to set 'search fuction' on tableau map, let's say i want to find specific location instead of City or States?

[@vizwiz]

Turn on the highlighter for that field.

[@sinofchaos10]

Is it possible to make it so that when you click on a state, it zooms/pans to that state and still shows the rest of the states around it?

[@nesreen1978]

Thanks!

[@vizwiz]

Thank you so much Nesreen!

[@DanShepherd-h8h]

I made a version based on this video that worked on tableau public desktop but when it was saved to tableau public it didn't clear out the zip code map on return to states. Seemed I was missing something to get the DZV to work right, so I bought the download and "ah ha!" a State Selected calculated field is the missing link. Works now on Public, not sure why it works on desktop without it.

[@vizwiz]

Very strange!

[@santoshdwivedi183]

Hello Andy, I have older version tableau desktop, and no option available 'control visibility using value' so how can do it..

[@apexsmart6337]

Simply download a newer version that supports it.

[@vizwiz]

You have to upgrade.

[@ShawnSpence-v7r]

I've done literally everything the same but my map won't zoom. Messes the whole thing up. Would really like a response bc right now I'm worse off than I was bc now people are expecting a map when I had a perfectly decent bar chart drilldown.

[@vizwiz]

Make sure you have changed your worksheet actions to dashboard actions. Also make sure the map isn’t pinned. Otherwise, if you follow the steps exactly, it will 100% work.

[@ShawnSpence-v7r]

unpinned, still doesn't really work. Now centers an area between Alaska and California, and when clicked zooms to lower 48, not the state. Centering on lower 48 being the reason why it was pinned, of course. Looks like actions were always dashboard actions so I'm not sure why that's being presented as an exception.@@vizwiz

[@ShawnSpence-v7r]

I click on the zip code to go back to the map, then try to click back in to zoom again and it's just blank screen. I have been fighting with this thing for days.

[@ShawnSpence-v7r]

LOL and now I can't even edit this. This is just impossible.

[@rajarshimaity6838]

Hello Andy. Great visualization. In fact in one of my assignments, i created a map drill down dashboard where I did a 3 level drill down - continent then country then state and at each level i was showing two measures. initially i used minimum data and the dashboard was performing well. Later when I introduced the whole dataset, performance drastically changed. Somehow I was able to bring the performance up a little but not too much. My design was a little different than yours. I will reapproach using this technique.

[@vizwiz]

The calculations need to be adjusted for 3 levels. Would it help if I created a video next week?

[@rajarshimaity6838]

@@vizwiz wow. That will be helpful. Thank you so much. Next week sounds just perfect

[@vizwiz]

My pleasure. It will help me learn how to use them better too. The technique should work with ANY combination of 3 charts.

[@vizwiz]

I've put it in my diary to create next week. Be sure to sign up to my newsletter so that you can get early access to it. andykriebel.com

[@rajarshimaity6838]

@@vizwiz surely I will do. I really appreciate all the hard work you do to create these videos.

[@madhvimalhotra2187]

Hi Andy, quick question, if I add more tables and charts in the dashboard with map drill down will it still work? Can you post a video with a dashboard with other graph, may be a bar chart or something

[@vizwiz]

It will still work as long as those charts aren’t part of those zones.

[@abhishek12865a]

Hello sir You are awesome please create a video on how to create a tableau dashboard which gives website like feel with multiple collapsible dropdown inside containers and much more usage of containers to wrap multiple sheets into a container .I'm very inspired by your sentence of kindly asking 1 pound you are awesome human being ..

[@NorahFahad-rn6uu]

what if i need for 3-level maps?

[@vizwiz]

I'll do you one better. Here's a 4 level drill down. kzbin.info/www/bejne/rWXZnayOls99ebcsi=vJblWJldf5LV3MPS Here's one for 3 levels. This uses a scatterplot, but there no reason you can't follow the exact same steps for a map. kzbin.info/www/bejne/hqLVeoiQer19naMsi=vx14dYF9nryPy2tr

[@IsabellaFaustini-e6w]

Excelente, gratidão!

[@tedjlegrand]

it doesn't work for me: when creating the dashboard and choosing "control visibility..." there is only None

[@vizwiz]

That means you are missing a boolean calculation that controls the visibility.

[@jacobs4985]

2:17