How to Apply Filter to All Worksheets in Tableau Dashboard

You’ve spent hours connecting data, crafting the perfect charts in Tableau, and arranging them on a beautiful dashboard. You add a date filter to let your team drill down into a specific month, but when you change the date, only one chart updates. Now you’re left with asynchronous charts and a dashboard that feels more broken than brilliant. It’s a common frustration, but luckily, it’s also an easy fix. This guide will walk you through exactly how to apply a single filter to all worksheets in your Tableau dashboard.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Tableau Filters Don’t Apply Everywhere by Default

First, it's helpful to understand why Tableau behaves this way. When you add a dimension (like Region, Date, or Product Category) to the Filters shelf on a specific worksheet, that filter is scoped to operate only on that single worksheet. It's a feature, not a bug.

Imagine a dashboard where you have three time-series charts showing daily sales, a summary table showing total sales for the entire year, and a bar chart of top customers of all time. You might want a date filter that controls the three daily charts but leaves the "all-time" summary visuals untouched. By limiting the filter scope by default, Tableau gives you the flexibility to build these kinds of nuanced dashboards without extra configuration.

However, in most cases, you probably want your filters - especially for things like date range, region, or campaign - to control the entire dashboard view. Let's look at a few ways to achieve that.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Method 1: The Quickest Way (Apply to All from the Dashboard)

This is the most common and direct method for making a filter control your entire dashboard. You’ll perform this action from the dashboard view itself after you’ve already added your worksheets.

Step-by-Step Instructions:

1. Add Your Worksheets to the Dashboard: Drag and drop the worksheets you’ve created onto your dashboard canvas. In this example, let's say we have two worksheets: "Sales by State" and "Profit by Category."
2. Show the Filter from One Worksheet: Go to any of the worksheets you've placed on the dashboard, click the small dropdown arrow to see more options, and navigate to Filters > [Your Filter Name]. For example, if you filtered by the Region dimension in your "Sales by State" worksheet, you would select that filter. The filter card will now appear on your dashboard.
3. Change the Filter Scope: Now, locate the filter card that just appeared on your dashboard. Click the small downward-facing triangle in the top right corner of the filter card to open its menu.
4. Select "Apply to Worksheets": Hover over the "Apply to Worksheets" option in the menu. This will reveal a sub-menu with several choices.
5. Choose "All Using This Data Source": To make the filter apply to every single sheet on the dashboard (and any future sheet you add from that same data source), select this option.

That's it! When you interact with the Region filter now, both the "Sales by State" and "Profit by Category" worksheets will update simultaneously. Test it by selecting a different region - you'll see your entire dashboard seamlessly update in response.

When to Use Other "Apply to Worksheets" Options

You’ll notice two other options in the "Apply to Worksheets" menu. Here's when you might use them:

• Only This Worksheet: This is the default setting. The filter will only affect the original worksheet it was created on.
• Selected Worksheets...: This option opens a pop-up window where you can manually check off each worksheet you want the filter to apply to. This is incredibly useful for more complex dashboards. For instance, if you want a date filter to affect charts showing Campaign ROI and Website Traffic but not a chart showing historical Customer Lifetime Value, you can specifically select only the first two.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Method 2: Use a Global Filter to Keep Things Clean

For large or complex dashboards, a common best practice is to manage filters from one of the worksheets on the dashboard rather than from within the worksheet's edit view. This approach treats the dashboard as the single source of truth for all your filter configurations, making your workbook easier to manage and debug later on.

Step-by-Step Instructions:

1. Apply the Initial Filter in the Worksheet View: Start by building one of your worksheets. Drag the dimension you want to use as a global filter (e.g., Ship Mode) onto the Filters shelf. Set up the filter configuration, such as a multi-select dropdown or single value list.
2. Build and Assemble Your Dashboard: Create your other worksheets and add all of them to your main dashboard view as you normally would. At this point, the Ship Mode filter you created in Step 1 still only affects its original worksheet.
3. Expose and Configure the Filter: In the dashboard view, find the worksheet to which you originally added the filter. Click its gray title bar to select the object, then click the small downward arrow that appears in the top right corner. From the dropdown menu, go to Filters > [Your Filter Name]. The filter card for Ship Mode will now be visible on the dashboard.
4. Apply to All Worksheets: Just like in the first method, click the small arrow on the filter card itself, go to Apply to Worksheets, and select All Using This Data Source.

This achieves the same outcome but keeps the modification process neatly contained within the dashboard environment. Many Tableau developers find this approach more intuitive because you’re actively viewing the sheets you’re trying to control as you apply the setting.

Troubleshooting Common Problems

Even after following the steps, you might run into issues. Here are a couple of the most common reasons why a global filter might not work as you expect.

Mismatched Data Sources

By far the most common issue is that your worksheets are built using different data sources. Tableau’s "Apply to All Worksheets Using this Data Source" function does exactly what it says - it only affects worksheets connected to that specific source.

• The Problem: You have a worksheet built on a Google Sheet of sales data and another worksheet built on a Snowflake connection of customer data. A filter based on a field from the Google Sheet can't be directly applied to the Snowflake worksheet.
• The Solution: The best fix is to properly join or blend your data sources within Tableau's Data Source tab. By creating a unified data source, all your worksheets can be built from it, and filters will work seamlessly. If that isn't possible, you'll need to use more advanced Tableau features like parameter controls or filter actions, which can create filter-like experiences across different data sources.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Filter is Already Present on Another Sheet

Sometimes, you might have the same dimension (e.g., Region) applied as a filter on multiple sheets, but with different configurations (e.g., one excludes "North" while the other doesn't).

• The Problem: When you try to apply a global filter, Tableau gets confused about which configuration should be the 'master' one.
• The Solution: It's best practice to remove the dimension from the Filters shelf on all worksheets except for the primary one you're using to control the dashboard. Add your filter to just one sheet, add that sheet to the dashboard, show the filter, and then apply it to all other worksheets. This establishes a clear hierarchy and prevents conflicting settings.

Final Thoughts

Turning a single-worksheet filter into a dashboard-wide controller is a fundamental step in making your Tableau dashboards truly interactive and useful. By navigating to the filter card's options and selecting "Apply to Worksheets," you can quickly sync all your visualizations and empower your users to explore the data dynamically.

Wrestling with filter scopes, data sources, and menu options in complex Business Intelligence tools is a familiar task for any analyst. Sometimes, however, you just need clear answers without getting lost in the setup. That’s why we created Graphed. We let you connect your data sources in a few clicks and build entire real-time dashboards just by describing what you want in plain English. Instead of learning a tool's dozens of granular settings to ask a simple question, you can chat with your data and get an interactive dashboard built for you in seconds.