What is a Dimension Filter in Tableau?

Putting all your data into a single chart can create a cluttered, confusing mess that doesn't really tell you anything. The real power of data analysis comes from your ability to focus on specific segments, compare different groups, and ask targeted questions. In Tableau, your primary tool for achieving this focus is the noble filter.

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

This tutorial will walk you through one of the most fundamental and frequently used filter types: the dimension filter. We'll cover what dimensions are, how to apply filters to them, and all the powerful options you have to slice and dice your data with precision.

First, A Quick Refresher: What are Dimensions and Measures?

Before you can filter a dimension, it helps to be crystal clear on what one is. In Tableau, your data fields are divided into two main categories:

• Dimensions: These are qualitative, categorical fields that you use to describe your data. Think of them as the "who, what, and where." They are fields like Customer Name, Product Category, Region, or Order Date. In the Tableau data pane, they are typically shown as blue pills.
• Measures: These are quantitative, numerical fields that you can perform mathematical operations on. Think of them as the "how much or how many." They include fields like Sales, Profit, Quantity, or Website Sessions. In the Tableau data pane, they are typically green pills.

A dimension filter, therefore, is simply a filter that you apply to one of your categorical, descriptive (blue) fields.

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

How to Create a Dimension Filter in Tableau

Getting started is as simple as a drag-and-drop. For this example, let's say we have a simple view showing Sales by Sub-Category, and we want to filter this view to only show certain regions.

To create the dimension filter, you just need to drag the Region dimension from the Data pane directly onto the Filters card.

Once you do, a dialog box will appear. This little box is your command center for the filter, and it comes with four powerful tabs: General, Wildcard, Condition, and Top. Let's break down what each one does.

Mastering the Dimension Filter Options

This is where the magic happens. Understanding these options will allow you to build precisely the view you need and answer incredibly specific questions with your data.

The General Tab

This is the default view and the one you'll use most often. It's designed for direct selection of the members within your dimension.

• Select from list: This shows you every unique value in your dimension (e.g., Central, East, South, West for the Region dimension). You can check the boxes next to the items you want to include in your view. If you have a long list, you can use the search bar to find values quickly.
• Custom value list: If you know exactly what you want to filter by, you can manually type the values in. This is handy when you don't want to scroll through a long list to find what you're looking for. Simply start typing and hit enter to add a value to your filter list.
• Use all: This option sits at the top and is selected by default. It means you are starting with all values included. Changing this will only matter if you plan on adding this filter to a dashboard for users to interact with.
• Exclude: See that little checkbox on the right? Ticking it completely reverses the logic of your filter. Instead of including the items you've checked, it will exclude them. This is extremely useful if you want to see everything except one or two specific items. For instance, filtering out "Returned" orders from a sales view.

The Wildcard Tab

This tab is your go-to when you need to filter based on partial text matches. It's perfect for text-heavy dimensions like Product Name or Customer Name.

Let's say you want to find all Sub-Categories that have the word "Tables" in their name. You can simply go to the Wildcard tab, type "Tables," and select your match type:

• Contains: Finds any record that includes the text you entered anywhere in the value. (e.g., "Tables")
• Starts with: Finds records that begin with your specified text. (e.g., "Book" would find "Bookcases")
• Ends with: Finds records that end with your specified text.
• Exactly matches: Finds records that are an exact match for the text you entered.

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

The Condition Tab

The Condition tab allows you to take your filtering a step further by setting rules based on a measure. This is how you can filter a descriptive field (a dimension) based on its quantitative performance (a measure).

This feature answers questions like, "Show me only the Product Categories that generated more than $200,000 in sales."

You have two options here:

• By field: The most common choice. You can select a field (like Sales), an aggregation (like Sum), an operator (like >,), and a value (like 200000). This would build the rule SUM(Sales) > 200000 and only show the Product Categories that meet this condition.
• By formula: For more advanced logic, you can write your own formula. For example, you could create a condition to only show categories where the profit in 2023 was higher than in 2022.

SUM(IIF(YEAR([Order Date]) = 2023, [Profit], 0)) > SUM(IIF(YEAR([Order Date]) = 2022, [Profit], 0))

The Top Tab

Finally, the Top tab is designed to help you quickly identify your best (or worst) performers. This lets you answer questions like, "Who are my Top 10 customers by profit?" or "Which are my bottom 5 products by quantity sold?"

Similar to the Condition tab, you have two main options:

• By field: Simply select whether you want to see the Top or Bottom performers, choose the number (e.g., 10), and then pick the measure and aggregation rule to rank them by (e.g., Profit (Sum)).
• By formula: Again, this is an advanced option allowing you to define your Top N list using a custom calculation.

Making Filters Interactive on a Dashboard

Applying a filter to a worksheet is great for your own analysis, but the real benefit comes when you add them to a dashboard for others to use. This empowers your audience to explore the data for themselves.

To make your filter visible on a worksheet or dashboard, just right-click the filter on the Filters card and select Show Filter. The filter control will appear on the right side of your view.

From there, you can click the dropdown arrow on the interactive filter to change its appearance and functionality. You have several choices:

• Single Value (List): A radio button list where users can only select one value at a time. Perfect for switching between singular views like different departments or time periods.
• Single Value (Dropdown): The same as above, but in a compact dropdown menu to save dashboard space.
• Multiple Values (List): The default, shows checkboxes that allow users to select as many values as they'd like.
• Multiple Values (Dropdown): A more compact way to allow multi-select, saving precious dashboard real estate.
• Custom List: Allows users to type in a list of values they're looking for, similar to the main filter settings.
• Wildcard Match: Provides users with a search box that supports wildcard matching, which is ideal for searching through long lists of names or products.

Choosing the right display option can significantly improve the user experience of your dashboard, making it easier and more intuitive to explore.

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

Dimension filters are a core building block of effective analysis in Tableau. They allow you to shift from broad overviews to granular, focused insights by selecting, excluding, and setting conditions for the categorical data that gives your analytics context. Mastering these filter options is a huge step toward creating dashboards that are not just informative but truly useful.

Building powerful, interactive reports in tools like Tableau requires you to learn your way around settings like these. At Graphed, we're taking a different approach by making data exploration feel more like a conversation. Instead of dragging pills and navigating filter menus, you can get the answers you need just by asking. Creating that same complex view of "Top 10 customers by profit in the East region, excluding returned orders" is as easy as typing that exact sentence, instantly giving you the focused chart you need without the technical overhead.