How to Drill Down in Tableau

Showing your top-level business data is great for a big-picture view, but true insights often hide deeper down. To find them, you need to go from a high-level summary to the specific details behind the numbers. This article will show you exactly how to do that by mastering the "drill-down" feature in Tableau, using both simple hierarchies and more advanced set actions.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What is 'Drilling Down' in Tableau?

Drilling down is the process of moving from a broad summary of your data to a more detailed level. Think of it like using Google Maps. You start with a view of the entire United States (high-level), then you zoom into California (a more detailed level), and then you zoom further into Los Angeles (a granular, specific level).

In data visualization, this means starting with, for example, your total annual sales, and then clicking to see sales by quarter, then by month, and finally by individual product. This capability is what transforms a static report into an interactive and exploratory dashboard. It allows you and your team to ask follow-up questions directly within the dashboard and uncover the "why" behind your data without needing to build a dozen different reports.

For businesses, this is incredibly valuable. Instead of just knowing that sales are down, you can drill down to see that sales are down in a specific region, for a particular product category, during the last two months. This level of detail empowers you to make specific, actionable decisions instead of just guessing.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Choose Your Method: Hierarchies vs. Set Actions

Tableau offers two primary ways to add drill-down functionality to your visualizations. Your choice depends on your data and the kind of user experience you want to create.

• Hierarchies: This is the simplest and most common method. It works perfectly for data with a clear, logical parent-child relationship, like geography (Country → State → City) or time (Year → Quarter → Month). It's quick to set up and very intuitive for dashboard users.
• Set Actions: This is a more advanced and flexible method. It gives you complete control over the drill-down experience and can be used on data that doesn't have a natural hierarchy. While it requires a few more setup steps, it unlocks a much more dynamic and custom interaction.

We’ll walk through how to build both, starting with the easier Hierarchy method.

Method 1: Drilling Down with Hierarchies

Hierarchies are the quickest way to enable drill-down functionality. If your dimensions have a logical order, this should be your go-to method. Let’s build a report showing sales by geographical location.

Step 1: Create the Hierarchy

First, you need to tell Tableau how your dimensions relate to each other. You do this in the Data pane on the left side of your screen.

1. Find the dimension that represents the highest level of your hierarchy. In our case, this is Country.
2. Drag the next level down, State, and drop it directly on top of the Country dimension.
3. A dialog box will appear asking you to name the hierarchy. You can name it something like "Geography" or "Location." Click OK.
4. You'll now see the new hierarchy in your Data pane, with Country and State nested inside.
5. Drag your next level, City, and drop it into the "Geography" hierarchy, placing it underneath State.

Your Data pane should now show a hierarchy named "Geography" containing Country, then State, then City, in that order. The order is important, as it defines the drill-down path.

Step 2: Build Your Visualization

Now, let's use this hierarchy in a chart.

1. Drag the Geography hierarchy from the Data pane onto the Columns shelf. You'll see that it adds the Country pill because it's the highest level in the hierarchy.
2. Drag your measure, let's say Sales, onto the Rows shelf.
3. You now have a simple bar chart showing Sales by Country. You can sort it descending to make it easier to read.

Step 3: Drill Down!

This is where the magic happens. Look at the Country pill on the Columns shelf. Notice that there is a small "+" sign next to the field name. This symbol indicates that it's part of a hierarchy and you can drill down.

• Click the "+" on the Country pill. Your view will instantly change. Tableau keeps the Country but adds the next level in the hierarchy, State, to the Columns shelf. Your bar chart now shows sales for every state, grouped within their respective country.
• Click the "+" on the State pill. The view will expand again to show sales by City, nested within each State.

To go back up, simply click the "-" sign that now appears on the pills. It’s that easy! Users viewing your dashboard will see these same plus and minus buttons and can explore the data themselves.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Method 2: Drilling Down with Set Actions

Sometimes a simple hierarchy isn't enough. What if you want to click on a bar in the chart itself to drill down, instead of a tiny '+' symbol? What if you only want to see the details for the one specific category you clicked on, not all of them? For this level of control, you need Set Actions.

Let’s build a drill-down bar chart for product categories and sub-categories.

Step 1: Create a Set

A "set" in Tableau is a custom field that defines a subset of your data. We're going to create a set that will hold the category the user selects.

1. In the Data pane, find the top-level dimension you want to drill down from. In our case, that’s Category.
2. Right-click on Category, go to Create, and then select Set.
3. Give it a name, like "Category Set." You don’t need to select any members right now, so just leave it empty and click OK.

You’ll now see "Category Set" in the Sets section at the bottom of the Data pane.

Step 2: Create a Calculated Field

Next, we need a calculated field that will reveal the next level of detail (Sub-Category) only if its parent Category is in our new set.

1. Click the dropdown arrow at the top of the Data pane and select Create Calculated Field.
2. Name the calculation something like "Sub-Category Drilldown."
3. Enter the following formula:

IF [Category Set] THEN [Sub-Category] ELSE "" END

This simple logic says: "If a Category is in our selected 'Category Set,' then show its Sub-Category. Otherwise, show a blank." Click OK.

Step 3: Build the Visualization

The setup for this view is slightly different from the basic bar chart.

1. Drag your original Category dimension to the Columns shelf.
2. Drag your new calculated field, Sub-Category Drilldown, and place it on the Columns shelf right next to Category.
3. Drag Sales to the Rows shelf.
4. Sort the chart descending by Sales to get a cleaner view.

Right now, your chart just shows Sales by Category. The sub-category column is present but appears blank, because nothing has been added to our set yet. That’s what the action in the next step will do.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 4: Configure the Set Action

This is the final step that connects everything.

1. In the top menu, go to Worksheet > Actions. (If you’ve added this sheet to a dashboard, go to Dashboard > Actions.)
2. In the Actions window, click Add Action and choose Change Set Values...
3. Configure the action as follows:
4. Click OK to close both windows.

Now, go back to your chart and click on one of the bars, like "Technology." Instantly, the view expands to show you the sales for the sub-categories within Technology (Phones, Machines, etc.). Click on the white space in your chart, and it collapses back to the original view. You’ve created a slick, interactive drill-down!

Final Thoughts

Mastering drill downs allows you to build much more insightful and exploratory dashboards in Tableau. For straightforward, structured data like dates or locations, hierarchies are fast and intuitive. For a more controlled and custom user experience, learning how to use set actions expands what's possible and lets you tailor the dashboard's interactivity precisely to your needs.

Of course, becoming proficient in tools like Tableau takes time. For teams who need answers without the steep learning curve, there's another way. We built Graphed to simplify this entire process. Instead of creating calculated fields and configuring actions, you can just ask a question like, "Show me our sales broken down by product category and sub-category" and get an interactive chart instantly. You can then ask follow-up questions to drill down conversationally, letting you explore your data without getting stuck on the setup.