How to Apply Filter to All Worksheets in Tableau

Building different views of your data on separate worksheets is a core part of working in Tableau. The real magic happens when you bring them all together on a single dashboard to tell a story. But if you have three different charts, you probably don't want three different sets of filters cluttering things up. This article will show you exactly how to apply a single filter to all relevant worksheets, creating a clean, interactive, and professional-looking dashboard.

Why Apply a Filter Across All Worksheets?

Applying a filter to every worksheet is often called creating a "global" or "dashboard" filter. The principle is simple: instead of forcing your audience to adjust filters on each individual chart, you provide one control that updates everything simultaneously. This offers several key benefits:

• Improved User Experience: It's simply easier and more intuitive. When a user filters by a specific month, region, or product category, they expect the entire dashboard to reflect that choice. A single, global filter makes your dashboard feel like a cohesive, interactive application rather than a collection of separate charts.
• Consistency and Accuracy: With individual filters, it's easy for a user to accidentally set conflicting criteria on different worksheets, leading to confusion and misinterpretation. A global filter ensures that every visualization on the dashboard is looking at the exact same slice of data.
• Saves Dashboard Space: Why show three separate "Region" filters when one will do the job? Using global filters cleans up your dashboard design, giving more room to your actual data visualizations.

Put simply, it's the standard practice for building high-quality, professional dashboards that are easy for anyone to use and understand.

How to Apply a Filter Across Multiple Worksheets

Tableau makes this process straightforward, offering a few options depending on how much control you need. The most common and direct method is using the "Apply to Worksheets" option directly from the filter shelf.

Let's use a common business scenario: you have a sales dashboard with three worksheets built from the same data source.

• A map showing sales by state.
• A bar chart showing sales by product category.
• A trend line showing sales performance over time.

Your goal is to add a single filter for "Region" that simultaneously updates the map, the bar chart, and the trend line. A user should be able to select "West," for example, and see only sales data for that region across all three visualizations.

Step-by-Step Instructions

Step 1: Build Your Initial Worksheet and Filter

Start with one of your primary worksheets. In our example, we'll start with the "Sales by State" map.

1. Make sure your visual is created. Here, we'd have states on the map, with sales data on the Color or Size mark.
2. Drag the dimension you want to filter by - in this case, Region - from your data pane onto the Filters shelf.
3. A dialog box will appear asking you which members (e.g., Central, East, South, West) to include. You can select "All" for now and click OK.
4. You'll now see the "Region" pill on your Filters shelf. Find that pill, click its dropdown arrow, and select Show Filter. The filter will now appear as a card on the right side of your worksheet.

At this point, the filter only affects this one worksheet. The next step is to expand its scope.

Step 2: Apply the Filter to Other Worksheets

This is where you make the filter global.

1. Go back to the Region pill on your Filters shelf.
2. Right-click the pill (or click its dropdown arrow) to open the context menu.
3. Hover your mouse over the Apply to Worksheets option. This will reveal another menu with several choices.

This is the most important part of the process. You'll typically see three main options:

Option 1: All Using This Data Source This is the most common and powerful option. When you choose this, the filter will be applied to every single worksheet in your workbook — including any new worksheets you create later — that uses this exact data source. This is the "set it and forget it" choice for making a filter truly global.

Option 2: Selected Worksheets… This gives you granular control. Selecting this option will open a dialog box listing all the other worksheets in your workbook. You can then individually check which sheets you want this filter to control. This is incredibly useful for complex dashboards where you may want a filter to affect some charts but not others. For instance, you might not want your filter for "Product Category" to alter a high-level KPI card that shows total company sales for all products.

Option 3: All Using Related Data Sources You’ll see this option if you have set up relationships or blending between multiple data sources. It allows the filter to work across different, but related, datasets. For example, if you're filtering by "Customer ID" and one data source has sales details and another has customer marketing info, this option would allow the filter to apply to sheets from both sources as long as "Customer ID" is the linking field.

For our sales dashboard example, we would choose "All Using This Data Source" since we want the region filter to impact all three worksheets which are all built from our primary sales data.

Step 3: Add Your Worksheets and Filter to the Dashboard

Now that your filter is configured to work globally, it's time to build the dashboard.

1. Create a new dashboard.
2. Drag your three worksheets (Sales Map, Product Bars, Sales Trend) onto the dashboard canvas.
3. Now, add the filter. Select any of the worksheets you just added to the dashboard (it doesn't matter which one). Click the small dropdown arrow that appears at the top right of its container, hover over Filters, and then select your newly shared filter (in our case, "Region").

The "Region" filter card will now appear on your dashboard. Test it out! Deselecting "East" should cause the states in that region to disappear from the map, the "East" data to be removed from the product bar chart, and the trend line to adjust accordingly. Congratulations, you've successfully created a truly interactive dashboard.

Pro-Tips for Managing Global Filters

Once you’ve mastered the basics, here are a few extra tips that will make your dashboards even better.

• Look for the Filter Icon: Tableau provides a helpful visual cue. When a filter pill on the Filters shelf is affecting multiple worksheets, a small data source icon (a cylinder with an arrow) will appear next to its name. This lets you see at a glance which filters have a global scope.
• Use "Only Relevant Values": This is a fantastic UX enhancement. Imagine you have two global filters: Region and State. When you add both to your dashboard, the State filter might still show states from all regions, regardless of your Region filter setting. To fix this, click the dropdown arrow on your "State" filter card and select Only Relevant Values. Now, if a user filters the dashboard to "West" region, the "State" filter will automatically update to show only West region states like California, Oregon, and Washington.
• Filter Placement Matters: On your final dashboard, think about where the user will look first. It's common practice to place global filters at the top or on a side navigation bar so they are easily accessible and clearly apply to the whole view.

Final Thoughts

Mastering how to apply filters across all your worksheets is a fundamental step in transitioning from creating simple charts to building powerful, user-friendly interactive dashboards in Tableau. By linking your visuals to a single set of controls, you create a more professional, consistent, and insightful experience for your audience.

Of course, the learning curve with traditional BI tools often involves mastering settings, menus, and configurations like these. At Graphed, we’re simplifying this entire process. We connect directly to your sources like Google Analytics, Salesforce, and Shopify, and then you just ask for what you need in plain English — like, “Show me a dashboard of Shopify revenue by marketing source over the last 90 days.” We build the real-time, fully-interactive dashboard for you instantly, skipping the manual setup so you can get straight to the insights.