How to Filter a Dimension in Tableau

Filtering your data is one of the most fundamental skills in any analysis, and in Tableau, it's what transforms a cluttered view into a focused, insightful report. But if you’re new to the tool, understanding how to properly filter your dimensions can feel a bit confusing. This guide will walk you through exactly how to filter dimensions in Tableau, from the basic drag-and-drop to more advanced techniques that will make your dashboards more powerful and interactive.

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

What Are Dimensions and Measures in Tableau?

Before we filter anything, let's quickly clarify what a dimension is. In Tableau, your data fields are divided into two main categories: dimensions and measures.

• Dimensions: These are qualitative, categorical data points. They are descriptive fields that you use to "slice" your data. Think of things like product names, customer regions, order dates, or shipping categories. In the Tableau Data pane, they are typically shown in blue.
• Measures: These are quantitative, numerical data points. They are the numbers you want to analyze and aggregate (sum, average, count, etc.). Examples include sales, profit, quantity, or website sessions. In the Data pane, they are usually shown in green.

In short, you use dimensions to group or break down your measures. For example, you might look at Sales (a measure) by Region (a dimension). Filtering a dimension means you're choosing to include or exclude specific categorical values - like only showing data for the "West" region.

How to Apply a Basic Dimension Filter

Getting started with filtering is straightforward. Tableau's drag-and-drop interface makes applying your first filter simple and intuitive. Let's use a common scenario: filtering a sales report by Product Category.

For this example, imagine you have a view that shows Sales by Sub-Category, but you want to narrow it down to only show sub-categories within the "Technology" category.

1. Drag the Dimension to the Filters Shelf: In the Data pane on the left, find the dimension you want to filter by - in this case, Category. Click and drag it directly onto the Filters shelf, located just above the Marks card.
2. Choose Filter Values from the Dialog Box: As soon as you drop the dimension onto the Filters shelf, a dialog box will appear. This box lists all the members of that dimension (e.g., "Technology," "Office Supplies," "Furniture"). Check the box next to the member(s) you want to include in your view. In our case, we would check "Technology."
3. Apply the Filter: Click OK. Your visualization will instantly update to show data only for the selected category. You'll now see only the sub-categories that fall under Technology, like "Phones," "Machines," and "Copiers."

That's it! You've successfully applied your first dimension filter. This action of dragging a field to the Filters shelf is the foundation for all filtering in Tableau.

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

Exploring the Different Filter Options

The general list we just used is the most common way to filter, but the filter dialog box offers several powerful tabs for more specific filtering criteria. Let's break down each one.

General Tab

This is the tab you start with. It allows you to manually select which members of the dimension to include.

• Select from list: This is the default option, where you check boxes next to the values you want to keep. You can also select the "Exclude" checkbox to do the opposite - keep all values except the ones you check.
• Custom value list: Lets you type or paste a list of values to include. This is helpful when you have a very long list and know the exact names you're looking for.
• Use all: Includes all members by default. This is often used as a starting point before applying a different type of filter from the other tabs.

Wildcard Tab

The Wildcard tab is ideal for text-based dimensions when you need to filter based on a partial match. For example, you want to find all customers whose last name starts with "S". You have four matching options:

• Contains: Finds values that include the text you enter anywhere in the string (e.g., searching for "Chair" would find "Chairs" and "Office Chairs").
• Starts with: Finds values that begin with the specific text.
• Ends with: Finds values that end with the specific text.
• Exactly matches: Finds values that are an exact match, which is useful for checking specific values from a custom list.

Condition Tab

The Condition tab unlocks a new level of filtering by letting you filter a dimension based on the values of a measure. This is extremely powerful for analytical purposes.

Filtering by Field

You can set a condition based on an aggregated measure. For instance, you could filter to only show Sub-Categories where the sum of Sales is greater than $100,000. To do this, you'd go to the Condition tab, select "By field," choose the "Sales" measure, select "Sum" as the aggregation, and set the operator to ">" with the value 100,000.

Filtering by Formula

For even more control, you can write your own custom formula. This is essentially a calculation that must return a TRUE or FALSE result. For example, to find all sub-categories with an average profit margin over 25%, you could write a formula like:

SUM([Profit]) / SUM([Sales]) > 0.25

Tableau will evaluate this for each member of the dimension and only keep the ones where the formula is true.

Top Tab

This tab lets you quickly find the top or bottom performers without having to sort a huge table manually. For example, you could easily show the "Top 10 Products by Profit."

To set this up, you'd select "By field," choose "Top," enter "10," and then select "Profit" as the measure and "Sum" as the aggregation. This will dynamically filter your view to only show the 10 products that generated the most profit.

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

Making Filters Interactive for Your Users

Applying a filter behind the scenes is great for you as the report creator, but what about the people viewing your dashboard? You'll want to give them control to slice and dice the data themselves. This is where Quick Filters come in.

After you drag a dimension to the Filters shelf, you can right-click it and select "Show Filter." This will add an interactive filter card for that dimension directly to your worksheet, which you can then customize. The default display type might be fine, but you have several options to create a better user experience.

Click the dropdown arrow on the top right of the filter card to see the customization options:

• Single Value (List): A list of radio buttons, allowing the user to select only one option at a time. Perfect for when you need to focus on a single category.
• Single Value (Dropdown): The same as above, but in a compact dropdown menu. This is great for saving space on a crowded dashboard.
• Multiple Values (List): The default, with checkboxes that let users select any combination of values.
• Multiple Values (Dropdown): A dropdown that opens a list with checkboxes. Again, this saves valuable dashboard real estate.
• Multiple Values (Custom List): Allows users to type in the values they want to match.
• Wildcard Match: Provides a text box where users can type partial text, working just like the Wildcard tab but interactively.

Advanced Filtering Techniques: Context and Cascading Filters

Once you've mastered the basics, two more advanced dimension filtering concepts will significantly elevate your dashboards: context filters and cascading filters.

Context Filters

Imagine you want to see the "Top 10 customers by sales in California." If you create a regular filter for State ("California") and a Top N filter for Customers ("Top 10 by Sales"), Tableau will first find the top 10 customers across all states and then show you which of those happen to be in California. This isn't what you want.

You want Tableau to first filter the data down to only California, and then find the top 10 customers within that subset. This is exactly what a context filter does. It creates a temporary, smaller dataset that other filters then operate on.

To create one, right-click a dimension on your Filters shelf (in this case, State) and select "Add to Context." The pill on the shelf will turn grey, indicating it's now a context filter. Now, your Top 10 filter will work as expected, finding the top performers within the context you've set.

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

Cascading Filters (Only Relevant Values)

Let's say you have filters for both Region and State on your dashboard. If a user selects "East" as the region, they probably don't want to see all 50 states in the State filter - they only want to see states within the East region (like New York, Florida, Massachusetts).

This functionality is called a cascading or dependent filter, and it's incredibly easy to set up.

1. Add both Region and State to the Filters shelf and show them as interactive filters on your view.
2. Click the dropdown menu on the State filter card.
3. Select "Only Relevant Values."

Now, the State filter will automatically update its list of available choices based on the selection made in the Region filter. This creates an intuitive and logical experience for your users, guiding them through the analysis instead of overwhelming them with irrelevant options.

Final Thoughts

Filtering dimensions is a core skill in Tableau that separates static reports from dynamic, analytical tools. By mastering everything from basic lists and wildcards to powerful context filters and user-friendly quick filters, you can effectively guide your audience to the most important insights in your data.

Learning the intricacies of different business intelligence tools is a powerful, but often time-consuming, process. At Graphed we created a way for anyone to get immediate answers from their data without that steep learning curve. We simplify the entire process by allowing you to connect your marketing and sales data sources in just a few clicks and build reports using simple, natural language - no need to drag and drop filters or worry about context. You just ask for what you need, and the dashboard appears in seconds.