Mastering 4-Level Map Drill Downs in Tableau

If you've enjoyed my previous tutorials on 2-level and 3-level drill downs in Tableau, prepare to take your skills to the next level.

I've got something unique for you: a step-by-step guide on creating a 4-Level Map Drill Down in Tableau!

What You'll Learn:
- How to drill down from a region to a state
- How to further drill down from a state to a county
- Finally, how to drill down from a county to a city

Prerequisites:
This is an advanced tutorial. Make sure you're comfortable with Tableau basics and have seen my 2-level and 3-level drill down videos.

Previous Videos:
2-Level Drill Down Tutorial

3-Level Drill Down Tutorial

Links & Resources:

Don't forget to hit that "Like" button and "Subscribe" for more exclusive Tableau tutorials!

[GER]

You will be the reason people ask me how I've gotten so good with Tableau. Much appreciated kind Sir, thank you for your videos. ♡

[data_beta_]

Super easy to follow for such an amazing technique. Thanks!

[ramkrishna]

Thank you Andy for making the drill down and filtering logic so simple and easy to understand :)

[jboyd]

Thanks! Truly adding to the body of knowledge for this profession and adding value to the world.

[anju]

This was a brilliant tutorial Andy. Thank you so much, its much appreciated.

[muhammadsajjad-pmxv]

Thanks Andy for Another Amazing Video ❤❤

[vyacheslavs]

To avoid specifying initial parameters for displaying the dashboard, you can simply remove the third condition: [Postal Code Parameter] != ' ' from "DVZ Region" variable. Then even if all parameters are empty, you can still see the Regions Map and can drill down from there as usual.

[AltafAlandwale]

My heart broke as I saw you as an Arsenal fan :D

[Baqon]

Great video! I do have a question, though. Is there a way to set it so that clicking on selects the city instead of going back to the Region view?

[tradeshow]

How do I make this feature function on a tablet or the Tableau Server? When I published the map was no longer drillable and would return nothing when selected. Is there a special publish setting that needs to be selected? Thank you though for posting this walk through as it was extremely helpful.

[imsajiv]

Didnt see the data set link in the description only the published workbook is present

[MuhammadHamza-hgem]

at 11:56 duration of the video, there is another way around the situation which is regarding the clearing out of the city parameter every single time in order to get back to the Region display.
This can be dealt by changing the code of DZV Region to the following:

([Region Parameter] = '' AND [State Parameter] = '' AND [City Parameter] = '')
OR
([Region Parameter] = '' AND [State Parameter] = '' AND [City Parameter] != '')

the "OR" statement in the code will deal with both the cases, of all parameters being empty or only the City Parameter being populated.

And this way there will be no need of manually clearing out the value inside city parameter.

[r.m.]

Anyone else having difficulty with the control visability on the dashboard. I followed everything but I do not see my DZV's showing up.

[yankiokdemir]

Hi Andy, I wanted to achieve a multi-select drill down with DZV by using sets but unfortunately set booleans (true or false) are not captured as a Boolean which you can set from Control Visibility. My idea was to create an empty set and when one or more values were selected from the first sheet, the set would become true, and 1st level would be hidden because I was going to set "SET=FALSE" for its visibility. There is an old method still to achieve that by using 2 axis for Latitude but I still want to build something with DZV. That could be a nice video topic :)

[AndianerWhhat]

Thanks @Andy Kriebel. Is there a way to disable multi selection in maps? Because this kind of killed it. I tested it in tableau public and it showed the same result. If it would work with multiple selections it would be also nice. Are there ways to achieve this?

[yeeyazz]

Hi Andy! I am from Thailand that I use shapefile in city so that I see false only. Can you help me ? Thank you.

[nolanstephenson]

Do you have a special setting that let's your map automatically zoom in and out? I seem to have everything working properly but when I click on a state for instance it doesn't zoom onto that state and same for county. Thanks!

[johnprimeaux]

For some reason, I have no county data in the superstore dataset. Any suggestions? I tried using the zip code information from USPS, but it only provides matches that have sales? I

[sukritis]

Hi Andy,
I am trying to make a dashboard for work where i need the drill downs to go like State, County, State Senate district, House district, Municipality, Zip Code and Census Tracts. The first issue I'm facing is that a lot of it is not recognized by Tableau. For example, I am using the ACS 2020 census tracts however Tableau does not recognize census tracts. Any advice on how to go about this? If I use Shapefiles, it works well for 1 geography but messes up the other ones.

Thanks!

[gonzalooderda]

Is possible to make with shapes, because in other parts of the world, the maps of tableau doesn´t recognize more than two levels. for example state and county.