How to Drill into a Bar Chart Using Sets in Tableau

In the Create Calculated Field Menu I will enter the following calculation and name this field Category Drill Down.

IIF([Region Drill Down Set],[Category],”)

This calculation is using an IIF function. IIF stands for an Immediate IF. If I were to read this like a sentence it would read IF a Region is in the Region Drill Down Set THEN return the Category Dimension ELSE return nothing.

Creating the second drilldown

Category set

The next thing we need to do is create a Set using the newly created Category Drill Down calculated field. To do this I will right-click on Category Drill Down, navigate to Create, and Select Set.

You will notice when creating this set that there are no options to select. If you recall from the Category Drill Down calculated field, it’s set up to return a Category when a Region is added to the Region Set. Right now that set is empty so it is returning a NULL so this is exactly what we want to see. Leave the selection blank and click OK to create the set and close the menu.

Sub-category drill down calc

The next Calculated Field I will create is to drill from Category to Sub-Category. I will right-click on Sub-Category, navigate to create, then select Calculated Field.

This will open the menu to create the calculated field. I will title this Sub-Category Drill Down and enter the following calculation.

IIF([Region Drill Down Set] AND [Category Drill Down Set],[Sub-Category],”)

With that we are ready to set up our view.

Creating the view in Tableau

Drill down using a stacked bar

To create the first view, I will start by dragging Region to the columns shelf and Sales to the rows shelf.

Now we need to add in our drill down calculated fields, so to do this I will drag them both to the Details Marks card.

In the above screenshot notice I highlighted the details icon to the left of the pills for our calculated fields. The next step is to click on that icon and change it to Color for both of them.

That is going to add a dual discrete color palette to the view. With that, our view is set up and ready to go. I am going to clean up some of the labels, fonts, and marks in the view and then add it to a dashboard.

How to drill down using multiple bars

To create my second view, I am going to start by duplicating the first one. To do this right-click on the sheet in the toolbar at the bottom of the authoring interface then select Duplicate.

In the new sheet I am going to drag Category Drill Down and Sub-Category Drill Down into the columns shelf. For now we will not see anything change.

I will clean up that view and add it to the same dashboard as the first view.

How to create dashboard set actions

Time to add the Dashboard Set Actions that will allow the user to click on a bar and drill in for further detail. To get started I will click on Dashboard in the top navigation and select Actions

In the Actions Menu I am going to click on Add Action and select Change Set Values

This will open the Add Set Action menu. In this menu I will change the name to Region Drill Down Set Action and select both of my sheets in the source sheets section. I will then choose the Region Drill Down Set in the Target Set dropdown and update the radio buttons at the bottom. My final selections will look like this.

I will click OK, closing the Add Set Action menu. Then I will click Add Action again and choose Change Set Value.

For my second set, I will repeat the same steps as above except this time I will target the Category Drill Down Set in the Target Set dropdown. I will close this menu by clicking OK.

We can see both actions setup in the Actions menu. I will confirm my actions by clicking OK again, closing the Actions menu.

An Introduction to Tableau Sets

Creating those Set Actions will allow the user to click on either of the views to drill into the detail. You should be left with functionality like the GIF below.

Until Next Time,
Ethan Lang
Director, Analytics Engineering
[email protected]