How Many Types of Filters in Tableau?

Knowing which Tableau filter to use is a game-changer for building an effective dashboard. Since filters are how you (and your users) drill down into data and uncover insights, getting them right is vital. This guide will walk you through the different types of filters in Tableau, how they work, and when to use each one.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Understanding Tableau’s Order of Operations

Before diving into the filter types, it’s essential to understand Tableau's order of operations. Tableau doesn't apply all filters at once, it follows a specific sequence. This hierarchy determines what data is available for subsequent steps, which can dramatically change your final visualization.

Think of it like a series of sieves, each one filtering the data before passing it to the next. The order is:

• Extract Filters: Filters the data you pull from the original source.
• Data Source Filters: Filters the data after it enters Tableau's environment.
• Context Filters: Creates a temporary, smaller data set for your worksheet.
• Dimension Filters: Filters your categorical data.
• Measure Filters: Filters your numerical data.
• Table Calculation Filters: Hides data from the final view without filtering it from the underlying calculations.

Keeping this sequence in mind will help you troubleshoot why a view might not look the way you expect and choose the right filter for the job.

1. Extract Filters

Extract filters live at the very top of the food chain. You use these when creating an extract (.TDE or .hyper file) from a larger data source. Essentially, you are telling Tableau to only pull a subset of the original data, leaving the rest behind.

When to Use an Extract Filter:

Use an extract filter when you’re working with a massive dataset and know you’ll never need all of it for your analysis. By filtering before the data is even pulled into the extract, you create a much smaller, faster file.

• Example: Your company has sales data going back 15 years, but your dashboard only needs to analyze the last three. You can apply an extract filter on the 'Order Date' field to only bring in data from the most recent three years. This drastically reduces the extract size and improves worksheet and dashboard performance from the start.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Data Source Filters

A data source filter sits just below an extract filter in the order of operations. It acts as a gatekeeper for the data source itself, applying its conditions to every worksheet and dashboard that uses it. Unlike extract filters, which only work with extracts, data source filters work for both live connections and extracts.

When to Use a Data Source Filter:

This filter is perfect for when you want to set a universal rule for an entire workbook. If you need to restrict the set of data available to all visualizations based on that source, this is your tool.

• Example: You are building a regional dashboard specifically for the West Coast sales team. You can apply a data source filter to only include data where the 'Region' is "West." Now, any chart or table you build from this data source will automatically be filtered for the West region, ensuring consistency and preventing anyone from accidentally including data from other regions.

3. Context Filters

Context filters can be a little tricky, but they are incredibly powerful. A context filter is an independent filter that creates a separate, temporary table (or "context") from your data. Any other filters you apply to that worksheet (like dimension or measure filters) will then run only on the data in this temporary table, not on the entire data source.

You can identify a context filter in Tableau by its gray "pill" color on the Filters shelf.

When to Use a Context Filter:

The primary use case for context filters is to control the order in which other filters are applied, especially "Top N" filters. They can also significantly improve dashboard performance on complex views.

• Example: Let's say you want to see the "Top 10 customers by sales in the Technology category." Without a context filter, Tableau would first find your top 10 customers across all categories and then filter that list to only ones who purchased from the Technology category. You might end up with only two or three customers.
• The Fix: By turning your 'Category' filter into a context filter, you first tell Tableau, "Create a temporary table with only Technology data." Then, your "Top 10 Customers" filter runs on that much smaller, pre-filtered table, giving you the correct result: the 10 highest-value customers within the Technology category.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

4. Dimension Filters

Dimension filters are the workhorse of your day-to-day analysis. These are the filters you apply to qualitative, categorical data - think Product Category, Region, Shipping Method, or Customer Name. These typically appear as blue pills in Tableau and offer several ways to slice your data.

Types of Dimension Filters:

• General Filter: This is the simplest option, where you can select members from a list (e.g., checking boxes for "East" and "West" in a Region filter). You can configure these as single-value lists, multiple-value lists, dropdowns, and more to give end-users the exact experience they need.
• Wildcard Filter: Perfect for text fields, this allows you to filter based on patterns. You can choose items that "Contain," "Start with," "End with," or "Exactly match" a specific string of characters. For instance, filtering products to show only those containing the word "Chair."
• Condition Filter: This option lets you filter a dimension based on a condition related to a measure. You specify a rule, and Tableau only shows the dimension members that meet it. For example, you could show only ‘Product Sub-Categories’ where the SUM(Sales) is greater than $100,000.
• Top N Filter: Similar to a condition filter, this finds the top or bottom N members of a dimension based on a measure. For example, finding your "Top 15 Products by Profit" or your "Bottom 5 States by Quantity Sold." As mentioned earlier, remember to pair this with a context filter if you want to find the Top N within another category.

5. Measure Filters

While dimension filters handle categories, measure filters take care of quantitative, numerical data like Sales, Profit, or Quantity. These are a green pill on the shelf and are used to limit your data based on a range of values.

When to Use a Measure Filter:

Use measure filters whenever you need to include or exclude data marks based on their numeric value. Dashboards often feature them as sliders, giving an end-user interactive control over the visible data.

• Example: Imagine you're analyzing order profitability. You could apply a measure filter on the ‘Profit’ field to only show orders where profit was between $0 and $50. Or, you could analyze shipping costs by filtering to only show orders with a shipping cost greater than $20.

6. Table Calculation Filters

The last filter in the order of operations is the table calculation filter. This one is unique because it doesn't filter out underlying data. Instead, it hides marks from your view after most calculations have been computed. The data for the hidden marks is still considered in calculations like RUNNING_TOTAL or PERCENT_OF_TOTAL.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

When to Use a Table Calculation Filter:

Use this filter when you need to base your filtering on the result of a table calculation itself, without disrupting the calculation.

• Example: You build a chart showing a running total of sales. You want to display only the months after the running total surpassed $200,000. If you used a regular measure filter (SUM(Sales) > 200000), it would remove the early months' data before the calculation runs, resulting in an incorrect running total.
• The Fix: By dragging your table calculation (RUNNING_SUM([Sales])) to the Filters shelf, you create a table calculation filter. This allows the running sum to be calculated correctly using all the data, and then it hides the marks that don't meet your criteria of "> $200,000," leaving you with the accurate final view.

Bringing It All Together

Understanding these different levels of filtering - from the broad strokes of an extract filter to the fine-tuning of a table calculation filter - is fundamental to building accurate, efficient, and insightful dashboards in Tableau. By leveraging the order of operations, you can ensure your filters interact in a way that surfaces the answers you need in a logical and performant manner.

Final Thoughts

From data source filters that set workbook-wide rules to context filters that enable complex "Top N" analysis, each type plays a distinct role. Getting comfortable with this hierarchy unlocks the full analytical power of Tableau, allowing you to build complex dashboards that answer nuanced questions with precision and clarity.

While mastering Tableau’s filter logic is a respected skill, we know the steep learning curve required often slows down modern marketing and sales teams. This frustration is a big reason we developed Graphed. Instead of learning complex orders of operation and wrestling with different filter types, you can just ask questions in plain English, like "Show me my top 10 products by sales in the technology category," and immediately get a real-time chart. We handle all the complexity of data wrangling so you can focus on getting answers, not learning how to build them.