What Are the Different Filters in Tableau?

Diving into Tableau for the first time can feel like opening up a massive spreadsheet with millions of rows. Filters are your single most important tool for cutting through that noise to find the specific answers you're looking for. This guide will walk you through the different types of filters in Tableau, explaining what they do, when to use them, and how they all work together.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Filters Matter in Tableau

At its core, filtering lets you narrow down your dataset to focus only on what's relevant to your analysis. Instead of looking at global sales for all time, you can filter your view to see sales for a specific region, product category, or time frame. Using filters effectively is the key to turning a sea of data into clear, actionable insights.

Proper filtering helps you:

• Improve Performance: Asking Tableau to process less data makes your dashboards and reports load faster, especially with large datasets.
• Increase Clarity: By removing irrelevant information, you make it easier for your audience to see the story your data is telling.
• Answer Specific Questions: Filters allow you to drill down and isolate the exact data points needed to answer precise business questions, like "How did our holiday marketing campaign in California perform?"
• Create Interactive Dashboards: Exposing filters to users lets them explore the data on their own, personalizing the view to see what’s most important to them.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

A Quick Note on Tableau’s Order of Operations

Before we break down the different filter types, it’s helpful to understand that Tableau applies them in a specific sequence, known as the "Order of Operations." This is important because the order can change the results of your analysis. You don't need to memorize every step, but knowing the basic hierarchy will help you troubleshoot why a view might not look the way you expect.

Think of it as a funnel. The data passes through each filter type one by one, and each step reduces the amount of data available to the next.

Here’s the simplified order for the filters we’ll cover:

1. Extract Filters: Applied first, these filter the data before it’s even saved in a Tableau Extract file.
2. Data Source Filters: Applied next, these filter the data at its source, affecting all worksheets that use it.
3. Context Filters: Applied after data source filters, these create a temporary subset of data for other filters to work against.
4. Dimension Filters: These are the standard filters applied to categorical fields.
5. Measure Filters: Applied last, these filters work on the numbers and aggregated values in your view.

Now, let's explore what each of these filter types does.

The 6 Main Types of Filters in Tableau

1. Extract Filters

An Extract Filter is used when you create a Tableau Data Extract (.hyper file), which is a saved, local copy of your data source. This filter limits the dataset before the extract is even created. It's the very first line of defense against massive, slow datasets.

• What it is: A pre-filter that reduces the size of your dataset before you begin your analysis in Tableau.
• When to use it: You're connecting to a huge database or file with years of historical data, but you only need to analyze the last 18 months. By creating an extract filter for the date range, you prevent Tableau from ingesting all the unnecessary historical data, which makes your workbook much smaller and faster.
• How to apply it:

2. Data Source Filters

Data Source Filters are applied to the data right after it comes into Tableau, but before a context filter is applied. The key difference from an Extract Filter is that it works on both live connections and extracts. A Data Source Filter affects every single worksheet that uses that data connection in your workbook.

• What it is: A global filter that restricts the data available for all sheets and dashboards connected to that source.
• When to use it: You want to exclude certain data from your entire analysis. For example, you might want to remove data from test accounts or exclude a product line that was discontinued and is irrelevant to all current reports. Setting this at the data source level saves you from having to apply the same filter to a dozen different worksheets manually.
• How to apply it:

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

3. Context Filters

A Context Filter is a special type of dimension filter. When you set a filter as "in context," Tableau creates a temporary, smaller dataset based only on that filter. All other dimension and measure filters are then applied on top of this temporary subset. This is crucial when you want one filter to apply before another.

• What it is: A dimension filter that gets priority in the order of operations, creating a dependent relationship between filters.
• When to use it: The classic example involves "Top N" filters. Imagine you want to see the Top 10 Customers by Sales in the Technology Category. If you create a filter for Category = Technology and another for Top 10 Customers, Tableau might calculate the Top 10 customers across all categories first and then show you which of them are in the Technology category. You might only end up with two or three customers. By adding the Category filter to context, you tell Tableau to first narrow the dataset to only Technology, and then find the Top 10 customers within that context.
• How to apply it:

4. Dimension Filters

This is probably the most common filter you'll use in Tableau. A dimension filter is used to include or exclude categorical data. Dimensions in Tableau are fields that are qualitative and can't be aggregated, like product names, customer names, regions, or dates. They are typically colored blue in the side panel.

• What it is: A rule that slices your data based on MEMBERS of a category.
• When to use it: Any time you want to see a portion of your data based on a category. For example: viewing sales data for just the "West" and "South" regions, or looking at performance for your "Corporate" and "Small Business" segments.
• How to apply it:

5. Measure Filters

Where dimension filters slice by category, measure filters slice by numbers. A measure filter works on quantitative data - the numeric fields you can do math on, like Sales, Profit, or Quantity. Measures are typically colored green in Tableau's side panel.

• What it is: A rule that limits your data based on a range or condition of aggregated numerical values.
• When to use it: You want to see data that falls within a specific numeric range. For example: finding all sales orders between $500 and $1,000, identifying products with a negative profit margin, or showing only days where website traffic exceeded 10,000 visitors.
• How to apply it:

6. Table Calculation Filters

Table calculation filters are a bit more advanced. Because they are applied last in the order of operations, they don't actually filter the data out of the view, they just hide it. The underlying data for the entire view is still there and is used to compute table calculations like 'Percent of Total' or 'Running Sum.'

• What it is: A filter that hides marks from your view after all the calculations have been processed.
• When to use it: You want to display results based on a table calculation. For instance, you might calculate Year-over-Year growth for sales but only want to show months with positive growth. A regular filter would remove the previous year’s data, making it impossible to calculate the growth in the first place. A table calculation filter computes the growth for all months first and then hides the ones that don't meet your criteria.
• How to apply it: This usually involves creating a table calculation first and then dragging that calculated field onto the Filters shelf to hide marks.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Final Thoughts

Filters are fundamental to building effective visualizations in Tableau. By understanding the different types and how they work together through the order of operations, you can go from high-level overviews to granular insights and answer nearly any question your data holds. Practice moving from broad (data source filters) to narrow (measure filters) will make you more efficient and confident in your analysis.

While mastering Tableau is an incredibly valuable skill, we know it often involves a steep learning curve of clicking through menus, configuring calculations, and managing filters. Often, the busywork of building the report takes more time than acting on the insight itself. At Graphed we’ve simplified this entire process. Instead of hunting for the right filter type, you simply ask in plain English, "Show me my top 10 customers by sales in the technology category," and our AI builds the interactive chart for you, pulling directly from your live data sources in seconds. It allows you to stay focused on the "what" and "why" of your data rather than the "how" of your dashboard tool.