How to Show Hierarchy in Tableau Dashboard

Showing different levels of detail in a report - like starting with sales by country, then drilling into states, and finally seeing results for individual cities - is fundamental to data analysis. In Tableau, this is handled through hierarchies, a feature that makes your dashboards interactive and easy to explore. This guide walks you through what hierarchies are, why they're so valuable, and how to create them step-by-step.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Hierarchy in Tableau?

A hierarchy in Tableau is an organizational structure for your data that lets you group related dimensions together. It arranges your fields in a logical order, typically from a broader, more general level down to a more specific, granular one. Think of it like a family tree for your data.

Some common examples of hierarchies include:

• Geography: Country → Region → State → City → Postal Code
• Time: Year → Quarter → Month → Day
• Product: Product Category → Sub-Category → Manufacturer → Product Name
• Company Structure: Division → Department → Team → Employee

When you create a hierarchy, Tableau adds a small plus sign (+) to the field pill in your worksheet. This simple icon acts as a magic button for your dashboard users, allowing them to "drill down" to the next level of detail with a single click. Conversely, a minus sign (-) appears, letting them "drill up" to a higher-level summary.

Why Use Hierarchies in Your Dashboards?

While you could create separate worksheets for each level of detail (one for country, one for state, one for city), using hierarchies is a far smarter approach. Here are a few key benefits of organizing your data this way.

1. An Interactive and Intuitive User Experience

The biggest win is for your end-users. Instead of being presented with a static, flat chart, they are given a tool for exploration. They can answer their own follow-up questions without needing you to build a new report. For example, they can see in a bar chart that the "West" region has the highest sales, and then click a single button to see which states within the West are the top performers. This empowers them to find insights on their own.

2. Cleaner, More Focused Dashboards

Dashboards can get cluttered quickly. By using a hierarchy, you can present multiple levels of analysis within a single chart. This saves valuable dashboard real estate and avoids overwhelming your stakeholders with too many visuals. Your initial view can be a high-level summary, with the option to explore deeper for those who are interested, keeping the main dashboard clean and to the point.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

3. It Preserves Analytical Context

When you drill down, you never lose your place. For instance, if you expand from State to City in a table, the State column remains, so you always know which state each city belongs to. This contextual trail is crucial for helping users understand the data's structure and how different levels relate to one another, preventing them from getting lost in the details.

4. Drastically Simplified Reporting

For you, the dashboard creator, hierarchies are a massive time-saver. You build one visualization, add the hierarchy, and you’re done. The alternative is building three or four separate charts and trying to arrange them on a dashboard with complex filters or sheet-swapping actions to simulate the drill-down experience. Hierarchies are built for this purpose and get the job done in seconds.

How to Create a Hierarchy in Tableau: A Step-by-Step Guide

Let's walk through building a simple geographical hierarchy using the Sample - Superstore dataset that comes packaged with Tableau. There are two easy methods to do this.

Method 1: The Drag-and-Drop Method

This is often the quickest and most intuitive way to build a hierarchy directly in the Data pane.

Step 1: Identify Your Fields In the Data pane on the left side of your Tableau worksheet, locate the dimension fields you want to group. For our location hierarchy, we’ll use Country, State, and City.

Step 2: Start The Hierarchy An easy mistake is dragging from the highest level down, the key is dragging the deepest level of detail onto the one above. So, drag the child field to its parent.

For example, to order your new location hierarchy starting with State and down to City — in a proper structure from broadest to most granular.

So drag the City field and drop it directly on top of the State field.

Step 3: Name Your Hierarchy A "Create Hierarchy" dialog box will appear. Give your hierarchy a logical name, such as "Location." Click OK.

You’ll now see your newly created "Location" hierarchy in the Data pane, with State and City nested neatly. However, you're not done, you need to add Country as well.

Then, go ahead and repeat the 'start a hierarchy' step of dragging & dropping the child field to its parent (above).

To have your hierarchy start displaying data from the top at the Country level, drag the Country dimension and drop it above the State field within the new "Location" hierarchy you just created.

And that’s it! Your final ordered hierarchy of Country → State → City is ready to use.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 2: The Right-Click Method

This method is just as easy and is useful when you have many fields at once to add to your hierarchy from a field set.

Step 1: Select Your Fields In the Data pane, select all the fields you want to include in your hierarchy. You can multiselect by holding down the Ctrl key (or Cmd on a Mac) and clicking each field you need. Let’s select Country, State, and City.

Step 2: Create the Hierarchy Right-click on any of the highlighted fields. In the context menu, navigate to Hierarchy → Create Hierarchy...

Step 3: Name and Order It The "Create Hierarchy" dialog box will appear. Give it a name, like "Location," and click OK. Tableau will create a new hierarchy for you, but keep in mind that with this method it will not order your fields from broadest (Country) to finest level (City). The easiest way to order them correctly is to drag and drop the dimensions as we performed in Method #1.

Using Hierarchies in Your Visualizations

Now for the fun part. Let's build a simple chart to see our "Location" hierarchy in action.

Building an Interactive Bar Chart

Step 1: Set Up the Basic Chart

• Drag your newly created “Location” hierarchy from the Data pane and drop it onto the Columns shelf.
• Drag a measure, like SUM(Sales), onto the Rows shelf.

Instantly, Tableau generates a bar chart showing the sum of sales by Country, which is the top level of our hierarchy. Notice the little + symbol on the Country pill in the Columns shelf. This is the drill-down button.

Step 2: Drill Down into the Data

Click the + on the Country pill. Your view will automatically expand to show sales by both Country and State. The chart now becomes more detailed. You'll see another + on the State pill.

Click the + on the State pill to drill down one level further to City. Now your bar chart shows a very granular breakdown of sales by city, all within the context of their respective states and countries.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Drill Up for a Higher-Level View

To go back up, simply click the - symbol next to the field you want to collapse. Clicking the - on the City pill will roll the view back up to the State level.

Tips for Making Your Hierarchies More Effective

Creating hierarchies is simple, but a sound strategy is key to avoiding user confusion. Here are a few best practices to keep in mind when creating yours.

1. Ensure a Logical Order

Hierarchies only work if the order makes sense. It's a structure your chart will follow. Always arrange your fields from the broadest category down to the most specific. If it makes sense to go Year → Month, use your user-experience to guide you towards a clear path.

2. Keep Hierarchies to a Sensible Depth

Just because you can create a seven-level hierarchy doesn’t mean you should. A super-deep hierarchy can become cumbersome to navigate, forcing users to click through many levels to get what they want. In most business cases, a hierarchy of 3-5 levels is ideal for providing detail without creating a frustrating experience.

3. Let Your Users Know It's Interactive

Not everyone will instinctively know what the small + icon means. It's often helpful to include a small text box or title on your dashboard with a short instruction, such as: "Click the + on the axis labels to see more detail." Small encouragements can drive interaction significantly.

Final Thoughts

Tableau hierarchies are a foundational feature that can instantly elevate your dashboards from static reports to interactive analytical tools. By organizing your related dimensions, you empower your audience to explore data on their own terms, drilling from a high-level overview down into the details that matter, all within a single chart.

Manually creating these relationships and configuring reports in BI tools takes time away from acting on insights. Spending hours dragging and dropping fields is better than exporting CSVs, but there's an even faster way. A major reason we built Graphed was to eliminate these manual steps entirely. Instead of configuring hierarchies, you can simply ask, "compare ad spend vs. revenue by campaign," and Graphed instantly builds the real-time dashboard for you, connecting directly to your live data sources like Google Analytics, Facebook Ads, or Shopify.