Unlock Powerful Tableau Drill Downs With Set Actions 🔍

If you’re still clicking around dashboards trying to “fake” a drill down — stop! In this video, I’ll walk you step-by-step through how to use Set Actions in Tableau to build a fully interactive bar chart drill down.

👉 Start here to level up faster:

Tableau Starter Kit → https://www.nextleveltableau.com/starterkit

Core Concepts Course → https://www.nextleveltableau.com/tcc

Next-Level Tableau → https://www.nextleveltableau.com/

I’ve helped thousands of Tableau analysts move from frustration to clarity using features like this — and once you master Set Actions, your dashboards will finally work like your users expect them to.

📌 If you’re ready to stop confusing your users and start building cleaner, smarter dashboards… you’re in the right place.

See how it all works below the video.

Are you looking to take your Tableau skills to the next level? Do you want to create dashboards that offer a dynamic and interactive experience? 

Look no further! 

This comprehensive tutorial will walk you through the process of creating a Year→Quarter→Month→Day Drilldown in Tableau.

🔹 What You'll Learn:

1. How to set up 2 parameters for drilldown functionality

2. How to perform 9 simple calculations that power your dashboard

3. How to implement 8 simple dashboard actions for enhanced interactivity

4. Introduction to dynamic zone visibility

🔹 Who Should Watch:

1. Data analysts looking to expand their Tableau toolkit

2. Business intelligence professionals aiming for dynamic reporting

3. Anyone who wants to unlock the full potential of Tableau

🔹 Why This Tutorial is Unique:

1. Step-by-step guide for each component: Parameters, Calculations, and Dashboard Actions

2. Introduction to advanced Tableau functionalities like dynamic zone visibility

3. Reusable examples to cement your understanding

4. Tips and tricks for maximizing the utility of your drilldowns

Don't miss out on upgrading your Tableau skills. 

Let's dive into the world of advanced Tableau functionalities and take your dashboards to the next level! 

Welcome to this comprehensive tutorial on creating a Yearly to Monthly Calendar Drill Down using Dynamic Zone Visibility in Tableau.

📌 What You Will Learn

🔑 Key Takeaways

🔗 Additional Resources

Unlock the power of Tableau's Set Actions to enhance your data visualizations! 

In this in-depth tutorial, I'll walk you through a step-by-step guide on how to create an interactive chart that allows users to drill down from monthly to daily data by simply clicking on a month. 

Ideal for analysts, business intelligence professionals, and anyone who wants to level up their Tableau skills.

What You'll Learn:

- How to set up Set Actions in Tableau

- Create interactive charts for effective data exploration

- Best practices for visualizing monthly and daily data

Who This is For:

- Data Analysts

- Business Intelligence Professionals

- Tableau Beginners and Enthusiasts

Prerequisites:

- Basic understanding of Tableau Desktop

Resources:

- Download the sample workbook: https://public.tableau.com/app/profile/andy.kriebel/viz/MonthtoDayDrillDown/Sheet1

- Data: https://data.world/vizwiz/sample-soda-sales

- Tableau official documentation on Set Actions: https://help.tableau.com/current/pro/desktop/en-us/actions_sets.htm

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

- https://www.vizwiz.com/2022/08/two-level-drill-down.html

- https://www.vizwiz.com/2023/06/map-drill-down.html

3-Level Drill Down Tutorial

- https://www.vizwiz.com/2023/08/dzv-drilldown.html

Links & Resources:

Workbook - https://public.tableau.com/app/profile/andy.kriebel/viz/4-LevelMapDrilldown/MapDrilldown 

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 new community Discord server
5. Notification about any upcoming events and opportunities to learn

and more. 

Sign up at andykriebel.com.

🆓 DOWNLOAD the data, plus a starter and completed workbooks:

https://andykriebel.gumroad.com/l/map-drill-down

🥁 See the viz in action:

https://tabsoft.co/3X0gGJU 

If you want to drilldown multiple levels in a scatterplot, this tip is for you. In this tip, I show you have to create a 3 level drilldown with a scatterplot.

Naturally after I showed how to create a 3 level bar chart drilldown, someone immediately asked how to do it with a scatterplot. Unlike the bar chart drilldown, the scatterplot will only show you marks for the current level. 

For example:

1. When I’m at the highest level, I see only regions.
2. When I drill down one level, I only see States within the Region selected
3. When I drill down one more level, I only see postal codes that are within the region and state I selected.

This example shows you how to drill down from Region to State to Postal Code. To use this for yourself:

1. Download the workbook
2. Copy all of the calculations into your workbook
3. Swap out the dimensions

Note that you will need to recreate the sets and set actions. This will work with any combination of 3 dimensions.

I've showed you in several videos and WatchMeViz live streams how to create a 2 level drill down. And naturally the follow up question is always, how can I go one level deeper? This tip has exactly what you're looking for. I show you how to create a 3 level drill down in Tableau.

This example shows you how to drill down from Category to Sub-Category to Segment. All you need to do for your situation is replace the dimensions I'm using with yours. This will work with any combination of 3 dimensions.

Check out the interactive version below the video.

This type is inspired by this example from Lindsey Poulter - https://public.tableau.com/app/profile/lindsey.poulter8872/viz/SetActionDrilldown/ChooseaMetric

Having looked at the original visualization this week (here), it was pretty clear to me that the creators desired to create a KPI style dashboard. In a way it's good that I picked up on it that way. However, it wasn't designed particularly uclarly well to communicate most efficiently.

I decided during Watch Me Viz that I would stick with their idea of a KPI dashboard, but design it in a way that I thought would be easier to understand.

As per normal, it took way too long to faff about with the formatting. I made a couple of small changes after I finished the live stream. Click on the image below the video to check it out. Leave a comment on the video on YouTube if you have any questions. (Comments aren't appearing on the blog for some reason).

Have a wonderful week!

There are tons of ways to create a single level drill down, but if you’re having issues creating a second drill down, this video is a guaranteed way to help you fix this problem.

Additional video - Single Level Drill Down 

In this example, I show you how to create an interactive scatterplot that allows the user to select a mark in a scatterplot to drill down to the underlying data. This tutorial shows you how to drill down from Sub-Category to Product. This process will work for any two dimensions.

Short and sweet this week. The data set is about the price of personal information on the dark web. There are three fields: Category, Product, and Price. To me, this looks like Superstore, so that's how I approached it. How can I visualize two fields that have a hierarchy?

In the video, I show you how to create a drill down with both a set action and a parameter action. Here's the video and below is the visualization.

Twice recently I've used parameter actions to create a single column drill down and drill up to mimic a hierarchy. 

1. HR Analytics KPI Dashboard (Viz • Blog post)
2. Makeover Monday Week 46 (Viz • Blog post)