Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Exclude a Filter in Tableau

Cody Schneider••8 min read

Ever built a perfect dashboard in Tableau only to realize you need to remove just one or two specific items from your view? Instead of carefully selecting dozens of data points you want to keep, it's often much easier to just tell Tableau what to leave out. This guide will walk you through several easy and effective ways to use exclude filters in Tableau to gain more precise control over your data visualizations.

GraphedGraphed

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.

Watch Graphed demo video

Why Exclude Instead of Include?

While an “include” filter is great for focusing on a few specific data points, an “exclude” filter is your best friend when you’re dealing with the inverse situation. It's not just a matter of convenience, using an exclude filter often makes your reports more robust and future-proof.

Here are a few common scenarios where an exclude filter is the superior choice:

  • Cleaning Up Your Data: You might need to remove test accounts, internal employee purchases, or entries marked as "null" or "N/A" from a real sales analysis. Excluding them ensures your metrics aren't skewed.
  • Removing Outliers: Let's say a Black Friday sale created a massive, one-day spike that throws off your month-over-month trend line. You can temporarily exclude that single day to get a more accurate view of typical performance.
  • Focusing on the Majority: Imagine you want to analyze sales performance across all fifty states except California. Selecting 49 states is tedious, excluding just one is quick and efficient.

The biggest advantage, however, is dynamic updating. If you have a filter to include 'Region A', 'Region B', and 'Region C', what happens when 'Region D' gets added to your data source? It won't appear on your report until you manually update the filter. An exclude filter - for example, "exclude Region E" - would automatically include the new 'Region D' without any extra work. This keeps your dashboards low-maintenance and always up-to-date.

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.

The Quick & Easy Way: The "Exclude" Checkbox

The most straightforward method for excluding values starts right in the main filter dialog. This is the perfect approach for one-off removals when you don’t need to reuse the filter logic elsewhere in your workbook.

Let's use the classic Tableau Sample - Superstore dataset as an example. Suppose you want to analyze profit by Sub-Category, but the "Tables" sub-category is consistently losing money and you want to see the results without it.

Here's how to do it:

  1. Drag the dimension you want to filter (in this case, Sub-Category) from the Data pane onto the Filters shelf.
  2. A filter dialog box will appear, listing all the available sub-categories. You'll see items like 'Art', 'Binders', 'Chairs', and so on.
  3. From the list, select only the item(s) you want to remove. For our example, just check the box next to Tables.
  4. Now for the most important step: in the bottom-right corner of the dialog box, check the Exclude box. This tells Tableau to flip the logic of your selection.
  5. Click Apply or OK.

Your visualization will instantly update to show all sub-categories except for Tables. The filter card on the shelf will now clearly indicate that it's an exclude filter by displaying the sub-category you've removed with a strikethrough effect.

Level Up Your Filtering: Using Sets to Exclude Values

What if you have a list of items you frequently need to exclude across many different worksheets? For example, your company might have a standard list of five test customer accounts that should never appear in any promotional analysis. Re-selecting them with the exclude checkbox on every new sheet is inefficient. This is where Tableau Sets come in handy.

A Set is a custom field that allows you to define a subset of your data. You can then use this subset to filter, group, or color-code your visualizations. Most powerfully, you can filter based on members that are "In" the set or "Out" of the set.

Creating and Using an "Exclude Set"

Let's build a set to exclude a few specific customers from our analysis.

  1. In the Data pane on the left, find the dimension that contains the members you want to exclude. In our case, it's Customer Name.
  2. Right-click on Customer Name and navigate to Create > Set.
  3. The "Create Set" dialog box will open. First, give your set a descriptive name, like "Internal Test Accounts".
  4. Now, go through the list and select the customer names you want to group together for exclusion. Let's pretend 'Aaron Bergman' and 'Aaron Hawkins' are our test accounts. Check the box next to their names.
  5. Click OK. You'll now see a new field named "Internal Test Accounts" in the Data pane under a "Sets" heading.
  6. Drag your "Internal Test Accounts" set to the Filters shelf.
  7. Your view will now update to show only data for Aaron Bergman and Aaron Hawkins. That's the opposite of what we want!
  8. To fix this, right-click the set on the Filters shelf and click Edit Filter... In the small pop-up dialog, simply check all the items again ('Out'), or make sure the 'In' selection is deselected from your list of options. Alternatively, right-click the Set pill on your Filter shelf and ensure the filter is set to "Exclude" rather than "Include". For older versions or clearer control, show the filter, right-click the heading, and select Exclude Values.

Your visualization is now filtering out every member of that set. The best part? If you need to filter out these same customers on a different worksheet, you don't have to repeat the process. Just drag the "Internal Test Accounts" set to the Filters shelf and you're done.

GraphedGraphed

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.

Watch Graphed demo video

For Complex Logic: Excluding with Calculated Fields

Sometimes your exclusion rules aren't based on a simple list of members. You might need to exclude data based on a specific condition, a date, or even a combination of criteria. For these complex scenarios, calculated fields give you unlimited flexibility.

A calculated field lets you use formulas and functions to create new data from your existing data source. For filtering, we can create a boolean calculated field that returns either TRUE or FALSE for each row, and then filter based on that result.

Example: Excluding Data from a Problematic Date

Imagine a data entry error occurred on November 23rd, 2022, corrupting all sales records from that day. You need to exclude them from your annual report.

  1. Right-click anywhere in the empty space of the Data pane and select Create Calculated Field.
  2. Name your field something clear, like "Exclude Corrupt Sales Date".
  3. In the formula box, you'll enter a logic statement that identifies the records you want to keep. The formula is:
  4. Let's break that down: [Order Date] refers to our date field. The <> operator means "not equal to". And #2022-11-23# is how you write a specific date literal in Tableau. This formula will check every row and return TRUE if the order date is not November 23rd, and FALSE if it is.
  5. Click OK.
  6. Find your new calculated field, "Exclude Corrupt Sales Date", in the Data pane and drag it onto the Filters shelf.
  7. The filter dialog box will appear with two choices: 'True' and 'False'. Since we want to keep all the rows where our formula returned 'True', check the box for True.
  8. Click OK.

You have now successfully excluded all data from that specific date using a precise, reusable rule.

Combined Logic Example:

You can make these calculations as complex as needed. For example, to exclude 'Chair' sales that also occurred in the 'South' region, the formula would be:

NOT ([Sub-Category] = "Chairs" AND [Region] = "South")

When you filter for True on this calculated field, Tableau will evaluate each row and keep it only if it's not a Chair sale from the South.

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.

A Quick Note on Tableau's Order of Operations

As you build more complex dashboards, it’s helpful to know that Tableau doesn’t apply filters randomly, it processes them in a specific sequence called the Order of Operations. Standard dimension filters - like our basic exclude filter - are applied well into this sequence.

Why does this matter? Imagine you have a Context Filter that’s set to only show data from the year 2023. If you then add a dimension filter to exclude sales an employee made in 2022, that exclude filter will have no effect, because the 2022 data was already removed by the context filter higher up in the operational pipeline.

Thinking about this hierarchy can help you troubleshoot why a filter might not be working as you expect. If your exclude seems to be ignoring data, check for other, more powerful filters that might be acting on the data first.

Final Thoughts

You now have three powerful methods to exclude data in Tableau: the straightforward "Exclude" checkbox for quick tasks, dynamic Sets for managing reusable lists, and flexible Calculated Fields for handling complex logical conditions. Mastering these techniques will give you a new level of precision and make tuning your reports much faster and more accurate.

For those moments when you wish you could skip the manual clicks, set creations, and calculated field syntax entirely, we built a simpler approach. With Graphed, you simply describe the report you need in plain English—like “Show me total sales by region for last quarter, excluding internal test accounts”—and our AI immediately connects to your live data to build the report for you. It lets you focus on the insight, not the setup.

Related Articles