What is Filter in Tableau?
A Tableau dashboard without filters is like trying to find a specific book in a library with no categories or search function - you have all the information, but it’s nearly impossible to find what you actually need. Filters are the fundamental tool you'll use to cut through the noise and focus your data stories. This tutorial will walk you through exactly what filters are, the different types you'll encounter, and how to apply them step-by-step.
What Exactly is a Tableau Filter?
Simply put, a filter in Tableau limits the data shown in your visualization. Think of it like a coffee filter: you pour everything in, but only the good stuff (the data you want to see) comes through. By applying filters, you can exclude irrelevant information and concentrate on specific segments of your data to answer precise business questions.
For example, instead of looking at global sales for all product categories over the last ten years, you could use filters to narrow your view to:
- Sales in just the "West" region.
- Performance of only the "Technology" product category.
- Data from the most recent quarter.
This ability to drill down is the foundation of interactive data analysis. You’re not just looking at a static report, you’re asking your data a series of questions, and filters are how you frame those questions.
The 6 Types of Filters in Tableau (And Why the Order Matters)
Tableau processes your filters in a specific sequence, known as the Order of Operations. This might sound a little technical, but the core idea is simple: some filters are applied before others, which affects what data is available for subsequent filters and calculations. Think of it as a series of gates, data must pass through one gate before it can reach the next.
Here are the six main types of filters, listed in the order Tableau applies them:
1. Extract Filters
An extract filter is applied when you first create an extract from your data source. An "extract" is a saved subset of your data that you can use to improve performance. By applying an extract filter, you’re telling Tableau not to even pull the filtered-out data from the original source. This is the most efficient filter type for improving performance because it reduces the total amount of data Tableau has to work with from the very beginning.
Example: You have a massive database with 10 years of sales data, a lot of which you don't need. You can create an extract filter to only pull in data from the last three years, making your entire workbook faster and more responsive.
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.
2. Data Source Filters
A data source filter works similarly to an extract filter but applies to both live connections and extracts. It restricts what data enters your workbook from the source. Any worksheet that uses that data source will be subject to this filter, making it a powerful way to set global conditions for your entire analysis. They are applied after extract filters but before context filters.
Example: A regional manager for the United States doesn't need to see sales data from Europe or Asia. You can apply a data source filter on the Country field to only include "United States," ensuring all analysis within the workbook is focused on their region.
3. Context Filters
Context filters are a special type of filter that creates a temporary, smaller dataset from which your other worksheet filters will operate. When you promote a regular dimension filter to a "Context Filter," you are telling Tableau to pre-filter the data based on your selection before applying any other dimension or measure filters on your worksheet. This is primarily a performance optimization tool.
Example: Imagine your dashboard analyzes sales by city, and you have filters for State and City. If you set the State filter to "Context," and select "California," all subsequent filters (like the City filter) will only run on the data for California's cities. This is much faster than running the City filter on all cities in the entire country.
4. Dimension Filters
These are the most common filters you’ll use. Dimension filters are applied to qualitative, categorical data - think fields like Category, Region, Product Name, or Customer Segment. When you drag a dimension to the Filters shelf, Tableau gives you several options:
- General: Lets you select specific values from a list (e.g., check the boxes for "Technology" and "Furniture").
- Wildcard: Filters based on text matching (e.g., show all product names that "Contain" the word 'Chair').
- Condition: Filters based on a rule you define for a measure (e.g., show categories where the sum of sales is greater than $100,000).
- Top: A specialized conditional filter to show the Top or Bottom N records (e.g., show the Top 10 products by profit).
Dimension filters are incredibly flexible and form the backbone of most interactive dashboards.
5. Measure Filters
While dimension filters work on categorical data, measure filters work on quantitative, numerical data. You apply these filters directly to a measure field, usually an aggregated one. For instance, you could use a measure filter to show only orders with a certain sales value or products with a profit margin within a specific range.
Example: You want to identify outliers in your sales data. You could drag the Sales measure to the Filters shelf and set a rule to only show records where SUM(Sales) is greater than $5,000. Or, you could create a view of all products and use a measure filter on Profit Ratio to see only those that are unprofitable (Profit Ratio < 0).
6. Table Calculation Filters
Table calculation filters are applied last in the order of operations. This is an important distinction because they don't filter the underlying data in the view - they only hide marks from the visualization after calculations have been performed. This is useful when you need to calculate something based on your full dataset (like a running total or a percentage of a total) but only want to display a subset of the results.
Example: Let's say you want to show the top 10 states by their running total of sales. First, you'd create a table calculation to compute the running total. Then, you would apply a table calculation filter to show only the rank from 1 to 10. The calculation itself needs all the states to be computed correctly, but the filter simply hides the states that aren't in the top 10.
How to Apply a Filter: A Step-by-Step Guide
Now that you know the theory, let's put it into practice. We'll use the sample "Superstore" dataset that comes with Tableau to apply a simple dimension filter.
Let's say our goal is to create a bar chart showing sales by sub-category, but we only want to see data for the "Technology" and "Furniture" categories.
Step 1: Build Your Basic View
Start by creating a simple bar chart. Drag the Sales measure to the Columns shelf and the Sub-Category dimension to the Rows shelf. You'll see a bar chart showing sales for all sub-categories.
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.
Step 2: Drag a Field to the Filters Shelf
Find the dimension you want to filter by - in this case, Category. Click and drag the Category dimension onto the Filters card, located to the left of your visualization.
Step 3: Select Your Filter Values
A "Filter" dialog box will pop up. This box shows you all the available members in the Category dimension. By default, it opens on the "General" tab.
Check the boxes next to Furniture and Technology. You can then click Apply to see the changes in your chart, or OK to apply the changes and close the dialog box.
Step 4: See Your Filtered View
Your bar chart will immediately update to show only the sub-categories that fall under "Furniture" and "Technology." The Category pill will now be present on your Filters shelf to show that an active filter is applied.
Making Filters Interactive for Your Viewers
One of the best features of Tableau is the ability to create dashboards that your audience can interact with. To do this, you can expose the filter controls to them.
Simply right-click the Category pill on your Filters shelf and select Show Filter. A filter control card will appear on the right side of your worksheet. You can click the dropdown arrow on this card to change its appearance - from a multi-value list to a single dropdown, slider, and more.
Quick Tips for Using Filters Effectively
- Mind the Performance: While filters are essential, too many complex, overlapping dimension filters on a large dataset can slow your dashboard to a crawl. Use extract, data source, and context filters to reduce the data at the source and improve performance.
- Guide Your Audience: Use filters to create a clear analytical path for your users. Think about a dashboard's primary purpose and provide filters that help answer the most obvious next questions.
- Apply Filters Across Multiple Sheets: When building a dashboard, you often want one filter to control several visualizations at once. You can do this by clicking the dropdown on your filter pill and going to Apply to Worksheets > Selected Worksheets... and choosing the relevant sheets from the list.
Final Thoughts
Filters are one of the most fundamental concepts in Tableau, serving as your primary tool for slicing, dicing, and narrowing your data to uncover specific insights. Mastering the different types - and understanding when and how to apply them - is a huge step toward building powerful, interactive, and efficient dashboards.
Learning how to navigate a powerful BI tool like Tableau takes a lot of time and practice. At Graphed we created a different approach for teams that want answers from their marketing and sales data without the steep learning curve. We connect to all your key data sources - like Google Analytics, Shopify, and Salesforce - and let you build dashboards and get insights just by asking questions in plain English. This allows your entire team to be more data-driven without having to become Tableau experts first.
Related Articles
How to Create Facebook Ads API for Claude Code
Create a Meta Marketing API access token that never expires, using a system user, so Claude Code can pull Facebook ad reports and manage campaigns.
ClickHouse vs Postgres: When to Switch to Columnar
Comparing ClickHouse vs PostgreSQL means matching storage architecture to workload. Row storage wins for transactions. Columnar wins for scan-heavy analytics.
Google Ads for Orthodontists: Get More Booked Consults
Most orthodontic Google Ads campaigns waste money on low-intent searches. The problem is structure, not the platform.