How to Exclude Values in Tableau

Need to clean up your Tableau visualization by hiding a few noisy data points? Excluding certain values is a fundamental skill for building clear and focused dashboards, whether you're trying to remove outliers, filter out irrelevant categories, or focus the narrative of your chart. This article walks you through several ways to exclude data in Tableau, from the simple right-click method to more flexible and dynamic calculated fields.

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 Quickest Method: Right-Click and Exclude

The most direct way to remove a data point from your view is by using the built-in "Exclude" command. This method is perfect for quick, ad-hoc analysis when you spot something you immediately want to hide.

Let's use the sample "Superstore" dataset that comes with Tableau. Imagine you've created a simple bar chart showing Sales by Sub-Category.

You notice that the "Tables" sub-category has high sales but is perhaps irrelevant to your current analysis, or maybe it's an outlier you want to temporarily remove.

Here’s how to exclude it in seconds:

1. Click on the bar representing "Tables" to select it.
2. Once highlighted, right-click on the bar.
3. In the context menu that appears, navigate to the "Exclude" option and click it.

Instantly, the "Tables" bar disappears from your chart, and the axis recalibrates.

What's Happening Behind the Scenes?

When you use this command, Tableau automatically creates a Set based on your selection and adds it to the Filters shelf. You'll see a new pill on your Filters shelf, likely named something like "Sub-Category (Exclude)."

If you edit this filter, you'll see a list of an In/Out set that Tableau created when it found and listed all the values and dimensions from the mark. You'll find it lists one of the dimensions (the sub-category Tables in this case). That helps when you need to quickly remove the item - you choose all items on the list.

While this method is incredibly fast, it's fairly static. It's best suited for one-off analyses rather than for dashboards that need to adapt to changing data automatically.

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 More Controlled Approach: Manual Filtering

A slightly more deliberate and flexible method is to manually create a filter yourself. This gives you more transparency and makes it easier to edit your exclusions later.

Continuing with our Sales by Sub-Category chart, here’s how to build an exclusion filter from scratch:

1. From the Data pane on the left, find the dimension you want to filter (in this case, "Sub-Category").
2. Click and drag the "Sub-Category" dimension directly onto the Filters shelf.
3. A dialog box will pop up, showing you a list of all available sub-categories. You can uncheck the items you wish to remove from the view. But there's a better way.
4. Select all the values in the general filter by ticking the All checkbox.
5. At the bottom right of the list, tick the "Exclude" checkbox.
6. Clear the "All" checklist. And, now check the box next to any sub-category you want to exclude, such as "Tables", "Bookcases", and "Supplies."
7. Click "Apply" or "OK."

Your chart will update to exclude these three categories. This approach clearly inverts the filter's logic - instead of selecting what to include, you are explicitly selecting what to exclude. The major benefit is clarity. You or a colleague can easily open the filter and see exactly which items are being intentionally left out of the visualization, which is much more manageable than trying to decipher the automatically generated set from the right-click method.

Using Sets for Reusable and Dynamic Exclusions

Sets are one of Tableau's most powerful features. A set is a custom field that groups members of a dimension into two categories: IN (members that are part of the set) and OUT (members that are not). You can leverage this IN/OUT logic to create robust, reusable exclusion filters.

Once you are already on the page that has the bar chart, right-click "Sub-Category." A long selection list will show up at which point you type in the option to either choose from a list (general), use wildcard, select from various conditions, or filter down for top values. The General option is simple and can manually toggle which data sets to include in which set. There is a way to configure this page that has buttons for Select All/ Deselect All and Select Everything From List to automate your set creation, but sometimes it is better and more efficient when there are specific ones that need to be grouped.

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

How to Create an Exclusion Set

1. In the Data pane, find the dimension you want to filter. Right-click on "Sub-Category." You'll do this to be able to access list options like Calculate Field, Create Group, Create a Combined Field, and so on. They offer several functions that you can then create a subset to use how you want to use the worksheet by dragging sets from the Data Pane section for creating subsets of the worksheet and creating rules based on two sections that could change later with user input on dashboards, like parameters controlling which records are in which subset of data at any one time, without ever having to rebuild the calculation with those fields ever again.
2. Navigate to Create > Set.
3. Give your set a descriptive name, like "Sub-Categories to Exclude."
4. In the dialog box, you'll see a list of all sub-categories. Select the members you want to exclude by checking the boxes next to their names (e.g., "Tables", "Bookcases").
5. Click "OK."

You now have a new "Sub-Categories to Exclude" field at the bottom of your Data pane under the Sets section.

Using the Set as a Filter

1. Drag your newly created set ("Sub-Categories to Exclude") onto the Filters shelf.
2. A small dialog box will appear. By default, it will show only the members IN your set. To exclude them, simply select the "Out" option.

This tells Tableau to only show data for members that are outside of your exclusion set. The main advantage of using sets is reusability. You can easily drag this same set onto other worksheets to apply the exact same exclusion logic consistently across your entire workbook.

Advanced Conditional Exclusions with Calculated Fields

What if your exclusion criteria are more complex? For example, what if you want to exclude all sub-categories that have never reached $20,000 in monthly sales? You can’t solve this with a simple right-click or a manual checklist. This is where calculated fields, particularly Level of Detail (LOD) expressions, become essential.

LOD expressions allow you to perform calculations at a specified level of detail, independent of what's currently in your view. We can use this to identify sub-categories based on a specific business rule and then filter them out.

Creating a Boolean Calculation for Your Rule

Let's build a calculation that returns "True" for sub-categories we want to keep and "False" for those we want to exclude.

1. Click the dropdown arrow at the top of the Data pane and select "Create Calculated Field."
2. Name the calculation something like "Keep - Monthly Sales > $20k."
3. Enter the following LOD expression in the formula box:

{FIXED [Sub-Category] : MAX({FIXED [Sub-Category], DATETRUNC('month', [Order Date]): SUM([Sales])})} > 20000

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

Breaking Down the Formula:

• {FIXED [Sub-Category], DATETRUNC('month', [Order Date]): SUM([Sales])}: The inner part of the formula calculates the total sales for each unique combination of Sub-Category and month.
• {FIXED [Sub-Category] : MAX(...)}: The outer part takes those monthly sales figures and, for each sub-category, finds the single highest monthly sales value.
• > 20000: Finally, the entire expression returns True if that highest monthly sales value is greater than $20,000, and False otherwise.

Using the Calculated Field as a Filter

1. Drag this new calculated field onto the Filters shelf.
2. A filter dialog will pop up asking which values (True or False) to include.
3. Check the box for "True" and click "OK."

Your view will now dynamically exclude any sub-category that has never had a monthly sales figure over $20,000. This method is incredibly powerful because it adapts automatically as your data updates. If a sub-category has a breakout month and crosses the $20,000 threshold, it will automatically appear in your viz the next time the data is refreshed.

Best Practices for Excluding Data

As you build more complex dashboards, keeping track of your filters and exclusions becomes important. Here are a few tips to stay organized:

• Comment Your Calculations: When using calculated fields for filtering, add comments preceded by // to explain the logic. This helps you (and your teammates) remember why the filter exists months later.
• Use Descriptive Names: Give your sets and calculated fields clear, descriptive names. "Sub-Categories without Office Supplies" is much clearer than "Set 1."
• Document in Dashboards: For shareable dashboards, consider using a text box or caption to briefly explain significant exclusions. A small note like, "Excludes returns and internal transfers," can prevent a lot of confusion.

Final Thoughts

Tableau provides a range of tools for excluding data, accommodating everything from quick visual adjustments to complex, rule-based filtering. Whether you are using a simple right-click, a manual list, a reusable set, or a powerful LOD expression, understanding these methods allows you to create cleaner, more focused visualizations that tell a clearer story with your data.

We know that mastering filtering in Tableau is just one piece of the puzzle. The bigger challenge is often just getting all your data - from marketing platforms, your CRM, and sales tools - into one place for analysis. That's why we created Graphed. Our platform connects to all your tools and lets you build real-time dashboards using plain-English questions, skipping the manual data wrangling so you can get straight to the insights.