Having a way to drill down into your data can be very useful. They’re great for when space is at a premium and for reducing cognitive load for the end user. I’m a big fan and I’ve used it a few times in my client projects at The Data School.

In the above screenshot, I can click on a Product and it will show me a breakdown of how much each Sub-Product contributes.

Let’s not waste any time and get straight to the tutorial (I will be using the Superstore dataset included with Tableau):

The picture below is for demo purposes. This is the structure that we want for our drill down. We want to be able to click on a Category and it shows us all of the Sub-Categories inside that Category. If the Category isn’t selected then it stays collapsed.

1. Place Category onto the Rows

2. Create a Set from the Category field

3. Create a calculated field called ‘Sub-Category Drilldown’ and place this onto the Rows

IF [Category Set] THEN [Sub-Category]
ELSE ”
END

4. Create a Set Action by going to ‘Worksheet’ at the top left of Tableau and clicking on ‘Actions…’. Next click on ‘Add Actions’ in the new window that pops up

5. Name this Set ‘Change Category Set Drilldown’ and make sure you have ‘Remove all values from set’ selected at the bottom right of this window

To tidy it up you can also hide the field label.

And here’s the final result:

The Data School
Author: The Data School