- Right click a dimension (Abc) field in the Data pane, then select 'Create' and choose 'Set'.
- Select a sub-category from the list, then click 'OK'.
- The Set field will appear in the Data pane.
- Drag the 'Set' field to Color on the Marks card.
- Go to the 'Worksheet' menu at the top of the screen and select 'Actions' to create a set action.
- An Actions dialog box will appear. Click 'Add Action' in the bottom-left corner, then choose 'Change Set Values'.
- The Add Set Action dialog box will appear. Enter a name for the set action.
- Select the worksheet where your chart is located.
- Click 'Select' under Run Action On.
- Select 'Category Set' as the target set.
- Select 'Assign values to set' under Running the action will.
- Select 'Remove all values from set' under Clearing the section will.
- Click 'OK' to save the set action.
- Right-click on the same dimension (abc) field, choose 'Create', then select 'Calculated Field'.
- Create a conditional formatting calculation using this formula:
How to Drill Down in Tableau
Try this guided demo to learn how to drill down in Tableau.
📌 Why this matters
Drill-down functionality transforms static charts into interactive exploration tools, letting you start with high-level insights and click deeper into specific areas of interest. This eliminates the need to create multiple separate visualizations for different detail levels. Beyond convenience, interactive drill-downs change how stakeholders engage with your data. Instead of passively viewing predetermined views, they can follow their own questions in real-time, discovering patterns and outliers they might never have thought to ask about in a static report.
Your product deserves an interactive demo
