Tableau Lesson 10 – Hierarchies | Dataplexa

Section I — Lesson 10

Hierarchies in Tableau

Hierarchies let you drill into your data at multiple levels of detail — from Year down to Month, or from Category down to Sub-Category — with a single click inside any chart.

What a Hierarchy Is

A hierarchy is a set of Dimensions arranged in a parent-to-child order where each level is a more granular breakdown of the level above it. The most familiar example is time: Year contains Quarters, which contain Months, which contain Days. Another common example from Superstore is the product hierarchy: Category contains Sub-Category, which contains individual Product Names.

When a field belongs to a hierarchy, a small + or − drill icon appears on its pill when it is placed on a shelf. Clicking + expands to the next level down. Clicking − collapses back up. This lets you navigate between summary and detail without touching the Data pane or adding new fields manually.

The Built-in Date Hierarchy

Tableau automatically creates a date hierarchy for every Date field in your data. The hierarchy has five levels — Year, Quarter, Month, Week, and Day — and it is always available with no setup required. This is why date fields behave differently from other Dimensions the moment you drag them onto a shelf.

Hierarchy Level	Example Values	Drill Direction	Typical Use
Year	2021, 2022, 2023	↓ drill to Quarter	Annual performance overview
Quarter	Q1, Q2, Q3, Q4	↓ drill to Month	Seasonal pattern comparison
Month	Jan, Feb … Dec	↓ drill to Week	Monthly KPI tracking
Week	Week 1, Week 2 …	↓ drill to Day	Weekly operations review
Day	1, 2 … 31	— bottom of hierarchy	Daily granularity analysis

Drill Icons on a Shelf — Mockup

Here is what the Columns shelf looks like at different levels of a date hierarchy drill, and what the + and − icons look like on the pill:

Columns Shelf — Date Hierarchy Drill States

Level 1

+ YEAR(Order Date)

Click + to drill down to Quarter

Level 2

− YEAR(Order Date)

+ QUARTER(Order Date)

Year + Quarter now on shelf

Level 3

− YEAR

− QUARTER

+ MONTH

Year + Quarter + Month

Creating a Custom Hierarchy

You can build your own hierarchy from any set of Dimensions that have a natural parent-to-child relationship. In Superstore, Category → Sub-Category → Product Name is the obvious product hierarchy. Creating it takes just a few seconds and makes exploring product data far faster.

In the Data pane, drag Sub-Category directly on top of Category. A prompt asks if you want to create a hierarchy. Click Yes. Tableau nests Sub-Category under Category.

Tableau asks you to name the hierarchy. Give it a clear name like Product. Click OK. A folder labelled Product appears in the Dimensions section with Category and Sub-Category nested inside.

To add a third level, drag Product Name onto the hierarchy folder and drop it below Sub-Category. The hierarchy now has three levels: Category → Sub-Category → Product Name.

Drag Category onto the Columns shelf and Sales onto Rows. A + icon appears on the Category pill. Click it to instantly drill into Sub-Category. Click it again to drill into Product Name.

Custom Hierarchy — Data Pane Mockup

Data Pane — Dimensions

📁 Product (hierarchy)

└ Abc Category +

└ Abc Sub-Category

└ Abc Product Name

📅 Order Date

Abc Region

Removing and Editing a Hierarchy

To edit an existing hierarchy — rename it, reorder levels, or add a new level — right-click the hierarchy folder in the Data pane and select Edit Hierarchy. To remove it entirely, right-click and select Remove Hierarchy. Removing the hierarchy does not delete the underlying fields — they simply move back to their original positions in the Dimensions section as independent fields.

Hierarchies in Dashboards

When a worksheet with a hierarchy is added to a dashboard, the drill icons remain active for viewers. This means your audience can explore the data at different levels of detail interactively — without you needing to build separate charts for each level. For a Category-level chart embedded in a dashboard, a viewer can click + to instantly see the Sub-Category breakdown, then click − to collapse back. This is one of the most powerful interactivity features in Tableau dashboards.

📌 Teacher's Note

Custom hierarchies are one of the most underused features in Tableau. Many beginners drag Category, Sub-Category, and Product Name onto shelves separately — which works, but produces a cluttered view. A hierarchy gives you the same three levels of detail in a single pill that drills on demand. The rule is simple: whenever you have Dimensions where one naturally contains another — Region contains State contains City, or Division contains Department contains Employee — group them into a hierarchy. Your charts become cleaner and your dashboards become more interactive with almost no extra work.

Practice Questions

1. Which icon appears on a hierarchy pill on the shelf to indicate that you can drill down to the next level?

2. How do you start creating a custom hierarchy in Tableau's Data pane?

3. Which option do you select when right-clicking a hierarchy folder in the Data pane to dissolve the hierarchy without deleting the underlying fields?

Next up — Lesson 11: Data cleaning overview — identifying and fixing the most common data quality problems before you build any charts.

← Previous Course Index Next →

Tableau Course