What is a Hierarchy in Tableau?

Working with data at various levels of detail, from a high-level yearly summary down to specific daily transactions, is a fundamental part of data analysis. Tableau's hierarchy feature is designed specifically for this purpose, allowing you to organize related fields and create a powerful drill-down experience in your visualizations. This article will walk you through what hierarchies are in Tableau, how they can make your reports more interactive, and the steps to create and use them effectively.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is a Tableau Hierarchy?

A Tableau hierarchy is a group of related dimensions arranged in a parent-child structure. It allows you to organize your data from a broad level of detail to a more granular one. Think of it as a logical path that enables you to "drill down" to see finer details or "roll up" to see a bigger picture within a single visualization.

The most common and intuitive example is a geographical hierarchy:

• Country
• State/Province
• City
• Postal Code

In this structure, Country is the highest level (the parent). Drilling down from Country reveals the State/Province data related to it. Drilling down further from State/Province shows the City data, and so on. This logical arrangement makes exploring data across different levels of granularity incredibly fluid and intuitive.

Other Common Examples of Hierarchies

Hierarchies aren't limited to just maps or locations. They're useful for any dataset where fields have a natural, nested relationship. Other popular use cases include:

• Time-based Data: Year → Quarter → Month → Week → Day
• Product Catalogs: Product Category → Sub-Category → Product Name
• Organizational Structure: Department → Team → Employee
• Web Analytics: Channel → Source / Medium → Campaign

By grouping these fields together, you signal to Tableau that they are connected, unlocking specific features that make your reports and dashboards much more dynamic.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Should You Use Hierarchies? The Core Benefits

Creating hierarchies is more than just an organizational trick, it provides tangible benefits that improve your entire reporting process, from building visualizations to sharing them with others.

1. Effortless Drill-Down and Roll-Up Analysis

This is the primary advantage. When you use a hierarchy in a view, Tableau automatically adds plus (+) and minus (-) icons to the field pills on your Rows or Columns shelf. Clicking the plus icon instantly expands the view to the next level in the hierarchy (e.g., going from Year to Quarter). Clicking the minus icon collapses it back up. This lets you and your audience explore different levels of detail on-the-fly without needing separate charts or changing the chart's structure manually.

2. Cleaner, More Organized Data Pane

In datasets with dozens or even hundreds of fields, the Data Pane on the left can quickly become cluttered. Instead of seeing separate dimensions for Country, State, City, and Postal Code scattered in an alphabetical list, you'll see a single, collapsible item named "Location" (or whatever you call the hierarchy). This tidy presentation makes it much easier to locate your fields and understand the relationships within your data model at a glance.

Graphed

Still Building Reports Manually?

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

Watch the Demo

3. Enhance the User Experience for Dashboards

For end-users interacting with a published dashboard, hierarchies are a game-changer. Imagine a sales manager viewing a dashboard that shows revenue by Product Category. With a hierarchy, they can click a button to drill down and see which specific Sub-Categories or even which Products are driving that performance. This empowers them to answer their own follow-up questions directly within the dashboard, creating a more engaging and self-sufficient analytics experience.

4. Keep Data in Logical Context

Hierarchies enforce a logical path for analysis. When you drill down from "United States" to "California," your view is now filtered to show data just for "California." The data stays connected and contextual. This prevents the confusion that can arise from applying unrelated filters and helps maintain a clear, understandable story as you move through different layers of your data.

How to Create a Hierarchy in Tableau (Step-by-Step)

Creating a hierarchy in Tableau is a simple process. Let's walk through the most common method using a geographical example with the fields Region and State.

Method 1: The Drag-and-Drop Method

This is the quickest and most common way to create a new hierarchy.

1. Identify Your Fields: In the Data Pane on the left side of your workspace, locate the dimensions you want to include in a hierarchy. Remember to start with the highest level. For our example, we'll start with Region.
2. Drag and Drop: Click on the child field (in this case, State) and drag it directly on top of the parent field (Region).
3. Create Hierarchy Window: As you hover State over Region, a "Create Hierarchy" call-out box will appear. Release the mouse button.
4. Name Your Hierarchy: A dialog box will pop up, prompting you to name your hierarchy. Choose a descriptive name, like "Location" or "Geography," and click OK.

You'll now see your new "Location" hierarchy appear in the Data Pane, with Region and State nested within it. The fields are indented to show their parent-child relationship.

Adding More Levels to an Existing Hierarchy

To add more granular levels like City, simply drag the City dimension from the Data Pane and drop it into the "Location" hierarchy group we just created. A horizontal black line will show you its position in the list. Make sure to place it beneath State to maintain the correct high-to-low granularity.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Reorder or Remove Fields

Hierarchies are flexible. If you accidentally put City above State, you can simply click and drag it into the correct position within the hierarchy group in the Data Pane.

To remove a field, right-click it within the hierarchy group and select Remove From Hierarchy. The field won't be deleted, it will simply move back to the main list of dimensions.

Using Hierarchies in Your Visualizations

Once your hierarchy is built, using it is just as easy.

1. Drag Hierarchy to View: Drag the entire hierarchy group (e.g., "Location") or just the highest-level member (e.g., Region) onto the Rows or Columns shelf.
2. Use the [+] and [-] Icons to Drill Down: When the hierarchy is on a shelf, you'll notice a small '+' icon on the pill. Clicking this icon will instantly expand the view to include the next level down. For example, if you started with Region on the Rows shelf, clicking '+' would add State to the rows, showing which states belong to each region. A '-' icon will appear on the parent field, allowing you to roll the view back up to the higher level with a single click.
3. Contextual Menu Drill-Down: You can also explore data directly from the visualization itself. Right-click on a header in your chart (e.g., the mark for the "West" region) and you'll see "Drill Down" in the context menu. Selecting this achieves the same result as clicking the '+' icon.

Best Practices for Using Tableau Hierarchies

To get the most out of this feature, keep these simple tips in mind.

• Logical Order is Key
• Use Clear Naming Conventions
• Date Hierarchies Are Often Automatic
• Don’t Over-Complicate

Final Thoughts

Mastering Tableau hierarchies is a simple yet transformative skill that improves the organization and interactivity of your visualizations. By organizing related dimensions into an intuitive drill-down path, you can make your dashboards more exploratory and clean up your workspace all at the same time.

While features like hierarchies make analysis quicker inside Tableau, manually building reports across all your data sources - from Google Analytics to ad platforms to your CRM - can still feel like an unending chore. That's where Graphed comes in to automate the entire process. With us, you can connect your marketing and sales data sources securely, then simply describe what report you need like "show my campaigns by revenue in a bar chart for the last 30 days" and instantly generate the real-time, interactive dashboards so you can spend your time finding insights, not manually building reports.