What is a Global Filter in Tableau?

When you build a Tableau dashboard with multiple charts and data views, you almost always want them to work together. A global filter is the key to making that happen, allowing you to control every worksheet on your dashboard from one central point. This guide breaks down what global filters are, how to set them up in just a few clicks, and when they're the perfect tool for the job.

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

First, A Quick Refresher: What is a Standard Filter in Tableau?

Before diving into "global" filters, let's start with the basics. In Tableau, a filter limits the data shown in a specific view or worksheet. When you drag a field - like Region, Order Date, or Product Category - onto the "Filters" shelf for a single worksheet, you're creating a standard, or "local," filter. By default, it only affects the worksheet you're currently working on.

For example, if you create a bar chart of sales by product and add a filter for the 'West' region, only that specific bar chart will be filtered. Any other worksheets in your workbook, like a map of profits or a line chart of sales over time, will remain unfiltered and show data for all regions. This is useful for isolated analyses but quickly becomes inefficient when you want your entire dashboard to tell a cohesive story.

Understanding Tableau's Filter Hierarchy

The magic of creating a "global" filter lies in understanding a concept called scope. The term "global filter" isn't an official name for a specific button in Tableau, instead, it's a common way to describe a filter whose scope has been expanded to affect more than just one worksheet. Tableau offers a few different levels of scope for your filters:

• Apply to This Worksheet Only: This is the default. The filter is entirely local and only affects the active sheet.
• Apply to Selected Worksheets: This allows you to hand-pick which worksheets in your workbook the filter should apply to. It's great for controlling a specific group of related charts while leaving others unaffected.
• Apply to All Using This Data Source: This is what most people mean when they say "global filter." The filter is applied to every single worksheet - visible or hidden - that is connected to the same primary data source.
• Apply to All Using Related Data Sources: This is the most expansive option. It applies the filter not just to worksheets using the current data source but to any worksheets using other data sources you have related via data blending.

Your goal determines which scope is best, but for creating a unified dashboard experience, the "All Using This Data Source" option is your go-to.

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

How to Create a Global Filter in Tableau: A Step-by-Step Guide

Promoting a standard filter to a global filter is surprisingly easy. Once you understand the concept of its scope, the process takes just a few clicks. Let’s walk through it with an example where we want to filter an entire dashboard by Region. Assume you have a dashboard with a map, a bar chart, and a table, all built from the same data source.

Step 1: Create a Basic Filter on Any Worksheet

Open any one of the worksheets that will be part of your dashboard. Find the dimension you want to use as your global filter (in this case, Region) from the Data pane on the left. Drag and drop it onto the Filters shelf.

Step 2: Configure Your Filter

A dialog box will pop up, asking you to configure the filter. For a dimension like Region, you can select which values to include. You might choose to show all values in a multi-select list or a dropdown. Make your initial selections and click OK. At this point, you have only created a local filter that affects this one sheet.

Step 3: Expand the Filter's Scope

This is where the magic happens. Find the Region filter you just added on the Filters shelf. Right-click on it to open the context menu. You will see an option called Apply to Worksheets. Hover your mouse over it.

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

Step 4: Select "All Using This Data Source"

From the submenu that appears, click All Using This Data Source. That's it! Your filter is now global. Tableau doesn't give you a loud confirmation, but you can see a small database icon appear next to the filter on the shelf. This icon signifies that its scope is now tied to the entire data source.

If you visit any other worksheets in your workbook using that same data source, you'll see the Region filter is now present on their Filters shelf too, with the same database icon.

Step 5: Add the Filter to Your Dashboard

Now, go to your dashboard. From one of your worksheets on the dashboard, click the small dropdown arrow, navigate to Filters, and select your Region filter. It will now appear as an interactive card on the dashboard. Any changes you make with this single control - like switching from 'West' to 'East' - will instantly and automatically update every single worksheet on the dashboard at the same time.

When to Use a Global Filter: Practical Examples

Global filters are ideal for providing a high-level, interactive overview of your data. Here are a few common scenarios where they work perfectly:

• Executive Dashboards: When you need to provide a top-level view of company performance, a global filter for Date Range (e.g., Year, Quarter, Month) is essential. A senior leader can select "Last Quarter" and see sales, marketing, and operational metrics update in unison.
• Regional Sales Dashboards: For analyzing sales performance, a global filter for Country, State, or Sales Territory allows a manager to effortlessly switch between regions and see all related charts (sales trend, top products, profit margin) update instantly.
• E-commerce Analytics: In an e-commerce dashboard showing website traffic, conversion rates, and revenue, a global filter for Product Category or Customer Segment can help you analyze the performance of different business lines holistically.

Common Pitfalls and Best Practices

While powerful, global filters can sometimes cause unexpected behavior if not managed carefully. Here are a few tips to keep in mind:

1. Apply to "Selected Worksheets" for More Precise Control

Sometimes, "All Using This Data Source" is too broad. You might have one worksheet on your dashboard that you want to remain static as a benchmark while others update. In that case, choose Apply to Worksheets > Selected Worksheets.... This gives you a checklist of all sheets, letting you pick and choose exactly which ones the filter should control.

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

2. Convert to Context for Better Performance

If you're working with a very large dataset, a global filter might slow down your dashboard because Tableau runs a new query for every worksheet each time the filter changes. To speed things up, right-click the global filter and convert it to context. This creates a "fixed," independent temporary table that subsequent filters query against, drastically improving performance.

3. Be Aware of Hidden Worksheets

A global filter applies to all worksheets using the data source, including ones that aren't on your dashboard. If you use hidden worksheets for calculations or formatting tricks, a global filter might impact them in unintended ways. Always be mindful of the full scope of your data source.

Final Thoughts

In short, a global filter in Tableau is simply a standard filter with its scope expanded to apply to all worksheets using a data source. This powerful feature saves time, creates intuitive and interactive dashboards, and ensures your data story is consistent across every chart and view.

While mastering filter scopes is a valuable skill in Tableau, it represents just one part of a significant learning curve. At Graphed, we focus on simplifying this entire process. You can connect all your data sources in just a few clicks and then use plain English to build real-time dashboards - filters, synchronizations, and all. By asking, "show my top ad campaigns by revenue and website traffic for last month," our AI creates the interactive dashboard you need on the spot, with charts that automatically work together. Give Graphed a try and spend less time navigating menus and more time finding insights.