How to Create Cascading Filters in Tableau

Building a dashboard in Tableau can feel like directing traffic. You have multiple streams of information, and you need to guide your users to the right insights without causing a jam. If a user selects "United States" from a country filter, they shouldn't have to scroll past London and Toronto to find a city. That's where cascading filters come in, creating an intuitive, guided experience. This tutorial will walk you through exactly how to set up cascading filters in Tableau to make your dashboards cleaner and more user-friendly.

What Exactly Are Cascading Filters?

Cascading filters, also known as dependent or hierarchical filters, are a set of two or more filters on a dashboard where the selections in one filter (the parent) determine the available options in another filter (the child). It's a simple concept that mirrors how we think about data in the real world.

For example:

• Selecting the Region "West" would update the State filter to only show California, Oregon, Washington, etc.
• Choosing the product Category "Technology" would update the Sub-Category filter to only show "Phones," "Accessories," "Copiers," and "Machines."

The flow is from broad to specific. This simple feature has a huge impact on the usability of your dashboards.

Three Big Reasons to Use Cascading Filters

While it might seem like a small detail, implementing cascading filters offers significant advantages:

1. A Better User Experience: This is the most important benefit. Instead of overwhelming users with hundreds of irrelevant options in a dropdown menu, you guide their analysis. It prevents them from selecting impossible combinations (like the state of Florida in the Northeast region) and makes the dashboard feel smarter and more responsive.
2. Faster Time to Insight: When users aren't hunting through long lists of options, they can find the answers they need much more quickly. Your dashboard becomes less of a data puzzle and more of an answer machine.
3. A More Professional Feel: Details matter. A dashboard with interconnected filters feels polished and well-constructed. It shows you've thought not just about the data itself, but about how people will actually interact with it.

How to Create a Simple Cascading Filter in Tableau

The most common way to create cascading filters in Tableau is incredibly straightforward. Let's build one using the classic Category and Sub-Category relationship, which you can find in the Sample - Superstore dataset that comes with Tableau.

Step 1: Set Up Your Worksheet

First, create a new worksheet. The visualization itself doesn't need to be complex, the key is to have the dimensions you want to filter by present in the view.

• Drag the Category dimension to the Rows shelf.
• Drag the Sub-Category dimension to the Rows shelf, placing it to the right of Category.
• Drag the Sales measure to the Text card in the Marks pane.

Your worksheet should now look like a simple text table showing the sales for each Sub-Category, nested within their master Category.

Step 2: Add Your Primary (Parent) Filter

Now, let's add the first filter.

• Drag the Category dimension from the data pane over to the Filters shelf.
• A dialog box will appear. Select all the categories and click OK.
• Right-click on the Category pill in the Filters shelf and select Show Filter. The Category filter will now appear on the right side of your view.

Step 3: Add Your Secondary (Child) Filter

Next, we'll do the same for the dependent filter.

• Drag the Sub-Category dimension to the Filters shelf.
• Again, select all options in the dialog box and click OK.
• Right-click on the Sub-Category pill in the Filters shelf and select Show Filter. You should now see both filters displayed.

Step 4: Connect the Filters

This is where the magic happens. By default, both filters are independent. If you uncheck "Furniture" in the Category filter, you'll notice the list of Sub-Categories in the second filter remains unchanged, although the actual text table updates. We need to tell Tableau to link them.

• Click the small downward arrow in the top right corner of the Sub-Category filter card.
• From the dropdown menu, select Only Relevant Values.

That's it! Now, test your work. Select only "Technology" in the Category filter. You'll immediately see the Sub-Category list shrink to show only Accessories, Copiers, Machines, and Phones. You have successfully created a cascading filter.

Creating Multi-Level Cascading Filters

What if you want to chain more than two filters together? The logic is exactly the same. You just need to apply the "Only Relevant Values" setting to each child filter in the chain.

Let's add Manufacturer as a third-level filter to our existing setup.

1. Drag Manufacturer to the Rows shelf, to the right of Sub-Category.
2. Drag Manufacturer to the Filters shelf, select all, and click OK.
3. Right-click the new Manufacturer pill on the Filters shelf and choose Show Filter.
4. Click the dropdown menu on the new Manufacturer filter card and select Only Relevant Values.

Now you have a three-level cascade:

• Selecting Category: Office Supplies limits the Sub-Category filter.
• Then, selecting Sub-Category: Binders limits the Manufacturer filter to only companies that produce binders.

A Pro Tip for Performance: Use Context Filters

When you're working with very large datasets (millions or hundreds of millions of rows), you might notice a slight lag after making a selection in a parent filter. This is a sign that Tableau is working hard to compute the possible values for the child filter.

You can dramatically speed this up by adding your parent filter to context.

A context filter is a special type of filter in Tableau. When you add a filter to context, Tableau creates a temporary, smaller dataset containing only the data that passes through that filter. All other filters on the worksheet will then process based on that much smaller dataset, which can lead to a major performance boost.

How to Add a Filter to Context

• Go to the Filters shelf.
• Right-click your highest-level parent filter (in our example, this would be the Category pill).
• Select Add to Context.

You'll notice the pill on the shelf turns gray. This is Tableau's visual cue that it's now a context filter. For dashboards with cascades based on high-cardinality dimensions (like customer names or postal codes), this trick can be a lifesaver.

Rule of Thumb: Apply context to your parent filter that produces the biggest data reduction.

Common Troubleshooting Steps

Sometimes things don't go as planned. Here are a couple of common issues you might run into and how to fix them.

1. The "Only Relevant Values" Option is Grayed Out

This is a frequent stumbling block. If you can't select "Only Relevant Values," it's almost always because your dimensions aren't linked within the worksheet itself.

The Fix: Make sure that all the dimensions involved in your cascading filter chain are present somewhere in the worksheet — on the Rows, Columns, Detail, or Color shelves. Tableau needs this context in the view to understand the relationship between the fields.

2. My Filters Aren't Working Across the Whole Dashboard

You've built a worksheet with perfect cascading filters, but when you place it on a dashboard with other worksheets, the filters only affect their original sheet.

The Fix: You need to tell the filters to apply to other worksheets. On the dashboard:

• Click the dropdown menu on the filter card you want to adjust.
• Hover over Apply to Worksheets.
• Select All Using This Data Source (if you want it to apply everywhere) or Selected Worksheets... to hand-pick which other sheets on the dashboard should listen to this filter.

You must do this for each filter in your cascading series to make them work globally across your dashboard.

Final Thoughts

Cascading filters are a fundamental technique for transforming a static dashboard into an intuitive, interactive analytical tool. By mastering the "Only Relevant Values" function and knowing when to use context filters, you can significantly improve the user experience and guide your audience to meaningful insights more efficiently.

Building interactive dashboards and tweaking settings in complex BI tools is a powerful skill, but it often requires a steep learning curve and hours of configuration. At Graphed , we built a solution that lets you skip the tedious parts. Instead of clicking through menus, you can simply ask for what you need in plain English - like "create a dashboard showing sales by region and state for this quarter" - and our AI data analyst builds it for you in seconds, automatically connecting to your live data sources. It puts the focus back on getting answers from your data, not wrestling with the software.