Introduction

Tableau users often face the challenge of exploring multidimensional data efficiently. Business users want to view high-level metrics but retain the ability to drill down into underperforming areas.

This tutorial demonstrates how to create a dynamic drill-down hierarchy in Tableau using Set Actions, allowing navigation from a summary view to deeper levels in your data.

What is a Dynamic Drill Down in Tableau?

Dynamic drill-down allows users to explore data across multiple dimensions. For example:

• Level 1: Category
• Level 2: Sub-Category
• Level 3: Manufacturer
• Level 4: Product Name
• Level 5: Customer Name

With Set Actions, users can click on Level 1 to drill down into Level 2 and so on, enabling hierarchical analysis for underperforming measures.

Challenges Addressed:

• Users need high-level summaries and the ability to explore deeper details.
• Developers must create dynamic hierarchies without manually creating multiple dashboards for each level.

Solution: Use cascading hierarchies with Set Actions in Tableau.

Step 1: Prepare Your Drill-Down Sets

1. Create a Set for Level 1 (Category):
   
   • Go to Dimensions → Level 1 → Create → Set → Name it Category Set.
   • Check a few values to form a temporary set.
     

Level 2 (Sub-Category):
IF [Category Set] THEN “↳” + [Sub-Category] END

1.  Create a Sub-Category Set using Level 2.

Level 3 (Manufacturer):
IF [Category Set] AND [Subcategory Set] THEN “↳” + [Manufacturer] END

Level 4 (Product Name):
IF ([Category Set] AND [Subcategory Set] AND [Manufacturer Set]) THEN “↳” + [Product Name] END

Level 5 (Customer Name):
IF ([Category Set] AND [Subcategory Set] AND [Manufacturer Set] AND [Product Set]) THEN “↳” + [Customer Name] END

Tip: Each calculation updates the set value dynamically based on user selection.

Step 2: Calculate Levels and Filters

• Level Number Calculation: Identify the current depth of drill-down.

IIF(NOT ISNULL([Level 5]), 5,

  IIF(NOT ISNULL([Level 4]), 4,

    IIF(NOT ISNULL([Level 3]), 3,

      IIF(NOT ISNULL([Level 2]), 2, 1))))

• Max Level:

{FIXED: MAX([Level No])}

• Filter Excess Records: Show only the active level.

[Level No] = [Max Level]

• Level Combined: Combines selected hierarchy for display.

IF ([Category Set] AND [Subcategory Set] AND [Manufacturer Set] AND [Product Set]) THEN [Level 5]

ELSEIF ([Category Set] AND [Subcategory Set] AND [Manufacturer Set]) THEN [Level 4]

ELSEIF ([Category Set] AND [Subcategory Set]) THEN [Level 3]

ELSEIF [Category Set] THEN [Level 2]

ELSE [Level 1] END

Step 3: Build the Drill-Down View

1. Drag Level 1–5 to Rows.
2. Add Level Header to Columns.
3. Uncheck Show Header for each row field.
4. Drag Level Combined to Text in the Marks card.
5. Apply Filter Excess Records to show only relevant levels.
6. Create a secondary sheet with your measure values (Quantity, Sales, Profit) and replicate Level fields.

Step 4: Create Set Actions

1. Go to Dashboard → Actions → Add Action → Change Set Values.
2. Name the action (Category Action) and select the source sheet.
3. Run action on: Select.
4. Target set: Choose the Category Set.

Repeat for Sub-Category, Manufacturer, and Product Name.

Step 5: Test the Drill-Down

• Clicking a mark updates the sets and drills down dynamically.
• Users can expand/collapse hierarchical levels with a single click.

Screenshot Suggestion: Include images of Level 1 → Level 5 expanding in the dashboard.

Advantages of Using Set Actions

• Provides interactive dashboards with user-driven hierarchy.
• Reduces complexity: No need for multiple dashboards per level.
• Helps in Qlik Sense to Tableau migration for maintaining drill-down functionality.

Conclusion

Dynamic drill-down with Set Actions in Tableau allows users to:

• Explore high-level metrics while diving deeper into details.
• Build interactive, multi-level dashboards efficiently.
• Maintain performance and usability with large datasets.

Implement this approach to make your Tableau dashboards more insightful, interactive, and user-friendly.