How to Use One Filter for Multiple Sheets in Tableau

Applying the same filter to every single worksheet in your Tableau dashboard can quickly become a repetitive headache. You build several amazing charts, bring them together into a dashboard, and then realize you have to manually filter each one to see how they interact. This article will show you how to use one universal filter to control multiple sheets at once, turning your static reports into a truly interactive and user-friendly dashboard.

First, What Is a Tableau Filter's Scope?

Before diving into the "how," it's helpful to understand the "why." By default, when you add a filter to a worksheet in Tableau, its scope is limited to just that single sheet. It doesn’t know you want it to affect the "Sales Trend" chart you built on a different sheet, even if they're both on the same dashboard and use the same data.

The good news is that Tableau provides an easy way to expand this scope. You can tell a filter to apply not just to the current worksheet, but to several selected worksheets, all worksheets using the same data source, or even all worksheets using related data sources. This simple change is the key to creating unified, interactive dashboards where users can explore the data from one central control point.

Let's walk through the exact process of setting this up.

Creating an Interactive Dashboard: A Step-by-Step Guide

To illustrate this, let's imagine we're building a sales dashboard using Tableau's sample "Superstore" dataset. Our goal is to create a dashboard with three charts - Sales by State, Sales by Category, and a monthly Sales Trend - that can all be filtered by Region using a single dropdown menu.

Step 1: Create Your Worksheets

First, we need the individual components of our dashboard. If you're following along, connect to the Sample - Superstore data and create the following three sheets:

Sheet 1: Sales by State Map

• Double-click the State field to generate a map.
• Drag the Sales field onto the Color mark on the Marks card.
• Rename the sheet "Sales Map."

Sheet 2: Sales by Category Bar Chart

• Drag the Sales field to the Columns shelf.
• Drag the Category field to the Rows shelf.
• Sort the bars in descending order for better readability.
• Rename the sheet "Category Sales."

Sheet 3: Monthly Sales Trend Line Chart

• Drag the Order Date field to the Columns shelf. Right-click it and choose "Month (May 2015)."
• Drag the Sales field to the Rows shelf.
• Rename the sheet "Sales Trend."

Step 2: Add the Initial Filter to One Sheet

Now, let's add our master filter. We'll add it to the "Sales Map" sheet first.

1. Navigate to your "Sales Map" worksheet.
2. Find the Region dimension in your data pane on the left.
3. Drag Region onto the Filters card.
4. A dialog box will appear. Select all the regions (Central, East, South, West) and click OK.
5. Right-click the "Region" pill you just added to the Filters shelf and select Show Filter. A filter control card will now appear on the right side of your view.

At this point, if you select a region from this new filter dropdown, you'll see the map update. However, if you check your other two sheets ("Category Sales" and "Sales Trend"), you’ll see they are completely unaffected. It’s time to fix that.

Step 3: Build a Simple Dashboard

To see our filter work its magic, we need to bring all our sheets together.

1. Click the "New Dashboard" icon at the bottom of the Tableau window.
2. From the dashboard pane on the left, drag your three worksheets ("Sales Map," "Category Sales," and "Sales Trend") onto the dashboard canvas. Arrange them however you like.

You'll notice that Tableau automatically adds the filter control for "Region" to the dashboard, since it was visible on one of the sheets you added. Right now, it still only controls the map. This is where we finally get to expand its scope.

Configuring the Filter to Control Multiple Sheets

On your dashboard, locate the "Region" filter card you just added. Click the small downward-facing arrow in the top right corner of the card to reveal its menu. Hover over the Apply to Worksheets option. This is the menu that controls the filter's scope.

You’ll see a few options, but we’ll focus on the two most common and powerful methods.

Method 1: Apply to "All Using This Data Source"

This is usually the simplest and quickest solution. By selecting this, you're telling Tableau to apply this filter to any and every worksheet in the entire workbook that is built on the same data source (in our case, the "Sample - Superstore" data).

How to do it:

1. On your dashboard, click the dropdown on the Region filter card.
2. Mouse over Apply to Worksheets.
3. Select All Using This Data Source.

That’s it! Now, try changing the region in the filter. You will see the map, the bar chart, AND the line chart all update simultaneously to reflect your selection. You've successfully created one filter for multiple visualizations.

When to use this method: Use this option when your dashboard is straightforward and every visualization on it should be affected by the filter.

Method 2: Apply to "Selected Worksheets"

What if your dashboard has a chart you don't want the filter to affect? For instance, you might have a KPI card at the top showing the total company sales for all time, which should never change regardless of the region selected. This is when you need more precise control.

The "Selected Worksheets" option lets you hand-pick which sheets the filter will control.

How to do it:

1. On the Region filter card dropdown, go to Apply to Worksheets.
2. This time, select Selected Worksheets....
3. A pop-up window will appear, listing all the worksheets in your workbook that use this data source. The current sheet ("Sales Map") will already be checked.
4. Simply check the boxes next to the other sheets you want this filter to control. In our example, you would click the checkboxes for "Category Sales" and "Sales Trend."
5. Click OK.

The result is the same as the first method for our current example. However, imagine you had a fourth sheet called "Total Company Profit" on the dashboard. By using this method, you could apply the filter to the three sales sheets while leaving the total profit visualization untouched. This gives you much more flexibility in designing complex dashboards.

When to use this method: Use this whenever you want a filter to affect some - but not all - of the sheets on your dashboard. It gives you precise, granular control.

Common Problems and Troubleshooting Tips

Sometimes things don't go as planned. Here are solutions to a couple of common issues you might encounter.

"The 'Apply to Worksheets' option is greyed out!"

This nearly always happens for one reason: you're trying to apply the filter from a dashboard instead of a worksheet. The master control for a filter's scope lives within the worksheet where it was originally created. If you find the option is disabled on the dashboard, just navigate back to the worksheet that has the filter ("Sales Map" in our case), click the dropdown on the filter card there, and you'll be able to set its scope perfectly.

"I selected a sheet, but the filter isn't affecting it."

This can occur if the dimension you are filtering by (e.g., 'Region') is not present in the visualization. A filter can only filter a view if that view is broken down by that dimension. To fix this, go to the worksheet that isn't working, and drag the filtering dimension (Region) onto the Detail shelf on your Marks card. This makes the dimension available to the filter without changing the fundamental structure of your chart. Once you do that, the worksheet will start reacting to your global filter.

Final Thoughts

Learning how to apply a single filter across multiple sheets transforms your experience in Tableau. You move from creating a collection of individual charts to building a cohesive, dynamic tool that empowers users to explore data and uncover their own insights. This is a fundamental skill that elevates the quality and professionalism of your work.

While mastering these skills in Tableau is empowering, we understand that busy marketing and sales teams don't always have time to become BI experts. That’s why we created Graphed. We connect directly to your data sources like Google Analytics, Shopify, and Salesforce and let you build reports with simple, natural language. Instead of wrangling menus and settings, you can just ask, "Create a dashboard showing our leads from Facebook Ads vs. Google Ads last quarter," and instantly get an interactive dashboard built for you - no configuration required.