When Can You Edit an Existing Filter in Tableau?

Editing an existing filter in Tableau is a fundamental skill you'll use constantly, whether you’re refining a sales report, changing a date range in your marketing dashboard, or tweaking a data source for deeper analysis. The good news is that the process is simple, and you can edit almost any filter you’ve created. This guide walks you through the common scenarios for editing filters and shows you exactly how to do it.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

First, A Quick Word on Tableau’s Order of Operations

Before jumping into the "how," it’s helpful to understand what happens when you use a filter in Tableau. Tableau processes your filters in a specific sequence, known as the Order of Operations. Understanding this hierarchy helps you predict how editing one filter will impact others.

Here’s the simplified order from first to last:

1. Extract Filters: Applied at the moment you create a data extract. These remove data from your dataset before you even start working in Tableau.
2. Data Source Filters: Applied to the entire data source, affecting every single sheet and dashboard connected to it.
3. Context Filters: These are powerful filters that create a temporary, smaller dataset that a sheet's other filters will use. They appear grey on the Filters shelf.
4. Dimension Filters: The most common type of filter, used on categorical data like names, regions, or product categories. They appear blue on the Filters shelf.
5. Measure Filters: Used on quantitative data like sales, profit, or quantity. They appear green on the Filters shelf.

You can edit filters at any of these stages. Knowing where your filter sits in this list helps you understand why changing a Data Source Filter has such a broad impact, while editing a standard Dimension Filter is much more localized.

When and How to Edit Different Filter Types

Most of the time, your reason for editing a filter will fall into one of a few common scenarios. Here’s a breakdown of the most frequent situations and an actionable guide for each.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Scenario 1: You Need to Refine Your View (Editing Dimension Filters)

This is the most common reason to edit a filter. You've built a visualization but now want to change which categories are included or excluded.

Example: Your bar chart shows sales by Sub-Category. You initially filtered it to show only ‘Chairs’, ‘Tables’, and ‘Bookcases’. Now, you want to remove ‘Bookcases’ and add ‘Furnishings’ to the mix.

How to Edit a Standard Dimension Filter:

1. Locate the Filter: Find the filter you want to edit on the Filters shelf. Dimension filters are typically represented by a blue pill (e.g., Category, Region).
2. Open the Edit Menu: Right-click the pill and select "Edit Filter..." from the dropdown menu. Alternatively, you can click the small downward arrow on the pill to open the same menu.
3. Make Your Changes: A dialog box will appear, giving you several ways to modify your filter.
4. Confirm and Apply: After you've made your changes, click "Apply" to see the results without closing the window, or just click "OK" to apply the changes and close it.

Scenario 2: The Timeframe for Your Analysis Has Changed (Editing Date Filters)

Date filters are edited constantly. A monthly report needs to be updated for the new month, or a stakeholder wants to see year-to-date data instead of just the last quarter. Editing these filters is an everyday task.

Example: Your dashboard shows website sessions for the "Last 30 days." You need to change it to show the full previous calendar year for an annual review.

How to Edit a Date Filter:

1. Locate and Open: Find your date filter on the Filters shelf (it will be a blue or green pill depending on whether it's discrete or continuous), right-click, and choose "Edit Filter...".
2. Choose a New Date Type: The date filter dialog box offers several flexible options.

You can switch between these types at any time. For instance, to go from a relative date to a fixed one, you'd click the radio button for "Range of Dates" and set your new timeframe.

1. Apply Your Changes: Click "OK" to update your view with the new timeline.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Scenario 3: Quantitative Thresholds Need Adjusting (Editing Measure Filters)

Filtering by measures lets you focus on data points that meet a certain quantitative standard, such as deals over a certain value, products with negative profit, or customers with more than five purchases.

Example: You have a scatter plot of Products by Profit and Sales, filtered to show only products with SUM(Sales) of at least $50,000. You want to edit this filter to be more restrictive, showing only products with over $100,000 in sales.

How to Edit a Measure Filter:

1. Find the Measure Filter: Locate the green pill on the Filters shelf representing your measure (e.g., SUM(Sales)).
2. Open the Edit Menu: Right-click and select "Edit Filter..."
3. Modify an Aggregation (If Needed): A pop-up may first ask how you want to aggregate the measure (e.g., SUM, AVERAGE, MEDIAN). You can change this if your logic requires it, but often you'll stick with the default and click "Next."
4. Adjust the Filter Rule: In the main dialog box, you'll have several options.

In our example, you would click "At Least" and change the value from 50,000 to 100,000.

1. Click "OK" to confirm your edits. Your visualization will instantly update to reflect the new, more restrictive threshold.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Scenario 4: You Need to Change the Foundation of Your Data (Editing Context and Data Source Filters)

This is a more advanced use case. Editing Context or Data Source filters should be done carefully, as they have a broader impact than standard dimension or measure filters.

Editing a Data Source Filter

A Data Source filter is applied before anything else happens in your worksheet. It reduces the entire dataset for every view created from that connection. You'd edit this if, for example, your initial setup excluded a certain year's data that you now need.

How to Edit a Data Source Filter:

1. Navigate to the "Data Source" tab in the bottom-left corner of the Tableau window.
2. In the top right, find the "Filters" section. Click the "Edit..." button.
3. If you have filters applied here, a dialog will show them. Select the one you want to edit and click "Edit..." again.
4. Make your changes just like you would with any other filter, then click "OK." Be aware that this change will now affect all worksheets using this data source.

Editing a Context Filter

A Context Filter acts as an independent, primary filter. All your other regular filters (dimension and measure) become dependent on what the context filter allows through. You essentially create a temporary subset of your data. To make a standard filter a context filter, you right-click it and select "Add to Context."

You'd edit one if the fundamental context of your analysis changes. For example, if you have a dashboard analyzing the Top 10 products, and the context filter is set to Region = 'East', then your Top 10 filter finds the top sellers in the East region. If you want to see the top sellers in the 'West' region, you need to edit the context filter.

How to Edit a Context Filter:

1. Find the grey pill on your Filters shelf. That's your context filter.
2. Right-click and select "Edit Filter..."
3. Make your change in the resulting dialog, such as changing the region from 'East' to 'West'.
4. Click "OK." The entire worksheet will recalculate based on this new context, and your other filters like the Top 10 will now find the top products in the West region.

Final Thoughts

Mastering your filters in Tableau is essential for dynamic data analysis. Whether you're refining a dimension, adjusting a date range, or changing a quantitative threshold, the process is straightforward: right-click on the filter and select "Edit Filter...". The key is to understand where the filter sits in the Order of Operations and what impact your edits will have.

Utilizing this understanding, you can make edits and create workflows that lead to better insights, allowing you to be efficient and precise with your Tableau analysis.