Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

What is Drill Down in Tableau?

Cody Schneider••9 min read

Ever create a beautiful summary chart only to have your team immediately ask, "Okay, but what makes up that number?" This is where learning to drill down in Tableau becomes a superpower. It transforms your static reports into interactive exploration tools, allowing you and your stakeholders to dig deeper into the data without needing to build a dozen different charts.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

This article will show you exactly what it means to "drill down" and cover the two most effective methods for adding this functionality to your Tableau dashboards. You'll learn the simple, built-in hierarchy method and the more powerful, interactive approach using dashboard actions.

So, What Exactly Does It Mean to "Drill Down"?

Drilling down is the process of moving from a high-level, summarized view of your data to a more detailed, granular level. Think of it like using Google Maps. You start with a view of the entire country (summary), then zoom into a specific state (first drill down), then a city (second drill down), and finally, a single street (the most granular level).

In business data, this could look like:

  • Starting with Total Annual Sales.
  • Drilling down to see Sales by Quarter.
  • Drilling down further to see Sales by Month.
  • And finally, drilling down to Sales by individual day.

Each step in the process "drills down" to a lower level of detail, revealing the specific components that make up the bigger picture. The opposite action, moving from detailed data back to a summary, is called "drilling up." By enabling both, you create a seamless way for users to explore the different layers of your data.

Why is Drill-Down Functionality So Useful?

Building drill-down dashboards isn't just a neat trick, it's a fundamental part of effective data analysis that offers several key benefits:

  • Uncover the "Why" Behind the Numbers: A high-level chart might show that Q3 sales were down. A drill-down can tell you why. Was it a specific product line that underperformed? A particular sales region? A key marketing campaign that ended? Drilling down helps you move from observation to diagnosis.
  • Empower Self-Service Analytics: Instead of sending analysts back to the drawing board every time a new question arises, a drill-down dashboard enables users to answer their own follow-up questions. This drastically reduces the back-and-forth and empowers everyone on the team to find their own insights.
  • Improve Data Storytelling: A great dashboard tells a story. Drill-down functionality creates a natural narrative flow, allowing you to present the executive summary first and then guide your audience through the supporting details in a logical and intuitive way. It makes the story more engaging and easier to digest.
  • Spot Anomalies and Outliers: Aggregate data can hide important details. Maybe your company's overall website conversion rate is a healthy 3%. By drilling down by traffic source, you might discover that Organic Search converts at 6%, while your expensive Paid Search campaigns are only converting at 0.5%. This is a critical insight you would've missed without drilling down.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Method 1: Using Hierarchies (The Easiest Way)

By far the simplest way to add drill-down functionality in Tableau is by using hierarchies. A hierarchy is a logical arrangement of fields in your data from most general to most specific. Tableau automatically recognizes certain relationships (like geographic data or dates) but you can also create custom hierarchies for anything.

Let's walk through an example using geographic data: Country, State, and City.

Step 1: Create Your Hierarchy

If Tableau hasn't created a hierarchy automatically, you can make one yourself in just a few seconds.

  1. In the Data pane on the left, find your geographic fields.
  2. Click and drag the most granular field onto the one above it. For example, drag the City field directly on top of the State field.
  3. Now, drag the State field directly on top of the Country field.
  4. Tableau will ask you to name the hierarchy. Let's call it "Location."

You'll now see a new field in your Data pane called "Location" with Country, State, and City nested neatly underneath it. The little tree-like icon indicates it's a hierarchy.

Step 2: Build Your Initial View

Now, let's build a simple chart to see this in action.

  1. Drag your new Location hierarchy onto the Columns shelf.
  2. Drag your measure, like SUM(Sales), onto the Rows shelf.

Your chart will automatically display Sales by Country, which is the top level of our hierarchy.

Step 3: Drill Down and Drill Up

Notice that the Country pill on your Columns shelf now has a small "+" sign next to it. This is your drill-down button!

  • To Drill Down: Click the "+" sign on the Country pill. The view will instantly expand to show you Sales by State within each Country. You'll see the pill on the shelf has changed to State, and it now has its own "+" sign. Click that, and you'll drill down again to the City level.
  • To Drill Up: Once you've drilled down, a "-" sign will appear. Clicking the "-" sign will collapse the view back to the previous level - from City back to State, and from State back to Country.

That's it! In just a few clicks, you have fully functional drill-down and drill-up capabilities right in your worksheet.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Method 2: Creating Interactive Dashboards with Set Actions

Hierarchies are fast and effective, but what if you want a more guided and visually clean user experience? For example, you might want to show total sales by product category on one chart, and when a user clicks a category (like "Fruit"), a second chart appears showing a breakdown of sales for just apples, bananas, and oranges.

This method keeps your dashboard clean by only showing the detailed view when it's requested. We can achieve this with Set Actions.

Let's build a dashboard that shows Sales by Category, and clicking a category drills down to a Sales by Sub-Category view.

Step 1: Create a Set

A set is a custom field that can group members from a dimension. In our case, we will use an action to dynamically add and remove a category from our set.

  1. In the Data pane, find the dimension you want to drill down from. In this example, it's Category.
  2. Right-click on Category and choose Create > Set.
  3. In the dialog box, name your set something descriptive, like "Category Set."
  4. Don't select any members. Just click OK. We'll populate this set using a dashboard action later.

Step 2: Create a Calculated Field for the Detail View

Next, we need a calculated field that will reveal our sub-categories only when their parent category is a member of the set we just created.

  1. Go to Analysis > Create Calculated Field.
  2. Name it "Drill Down Sub-Category."
  3. Enter the following formula:

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

This calculation is simple but powerful. It checks if a Category has been added to our "Category Set." If it has, the calculation returns the corresponding Sub-Category. If it hasn't, it returns a blank string ("").

Step 3: Build Your Two Worksheets

Now we need two separate charts: a high-level summary chart and a detailed chart that uses our new calculated field.

Worksheet 1: The Category Summary

  • Drag Category to Columns.
  • Drag SUM(Sales) to Rows.
  • Let's name this sheet "Category Sales."

Worksheet 2: The Sub-Category Detail

  • Drag your new calculated field, Drill Down Sub-Category, to Columns.
  • Drag SUM(Sales) to Rows.
  • Right-click the empty string value "" from the x-axis that may appear and select Exclude to hide it.
  • Let's name this sheet "Sub-Category Sales Detail."

Step 4: Combine on a Dashboard and Create the Action

This is where the magic happens. We'll put our two sheets on a dashboard and link them with an action.

  1. Create a new Dashboard by clicking the dashboard icon at the bottom of the screen.
  2. Drag both "Category Sales" and "Sub-Category Sales Detail" worksheets onto the dashboard canvas.
  3. Now, go to the main menu and select Dashboard > Actions....
  4. In the Actions window, click Add Action > Change Set Values....
  5. Configure the action as follows:
  • Name: Give it a clear name like "Category Drill Down."
  • Source Sheets: Select your dashboard, then make sure only the Category Sales sheet is checked.
  • Run Action on: Choose Select. This means the action will fire when a user clicks a bar.
  • Target Set: Under data source, select the Category Set you created in step 1.
  • Clearing the selection will: Select Remove all values from set. This ensures that when you click off a bar, the detail chart becomes empty again, resetting the view.
  1. Click OK twice to close the windows.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Step 5: Test Your Interactive Drill Down

Your dashboard is now ready. Click on any bar in your "Category Sales" chart (e.g., "Technology"). You will instantly see the "Sub-Category Sales Detail" chart populate with bars for Phones, Accessories, Copiers, and Machines. If you click a different category bar, like "Office Supplies," the second chart will update to show Binders, Labels, Paper, and Storage.

When you click in the white space of the first chart to deselect the bar, the second chart will go blank. Congratulations, you've just built a clean, intuitive, and powerful drill-down dashboard!

Final Thoughts

Whether you use the straightforward hierarchy method or the more versatile Set Actions, adding drill-down capabilities is a transformational step in Tableau. It turns your dashboards from static reports into dynamic investigative tools, empowering everyone to go beyond the summary numbers and discover the real stories hidden in your data.

Building these functionalities in tools like Tableau marks a major step up in data literacy, but it still requires learning specific features and processes. As part of our work, we've focused on making this kind of deep-dive analysis even easier. With a tool like Graphed, you simply connect your data sources and describe the multi-layered view you need in plain English - for example, "Show me my sales by category, and let me click to see the sub-categories." Our AI data analyst then builds the interactive, real-time dashboard for you in seconds, saving you the steps while delivering the powerful insights you're after.

Related Articles