How to Remove All from Filter in Tableau

Ever built a beautiful Tableau dashboard only to have the “(All)” option in a filter clutter the view or, worse, crash the server when a user selects it? You're not alone. While the default "All" selection is useful, sometimes it causes performance issues or goes against the guided analytics experience you’re trying to create. This guide will walk you through several clear methods to remove the "All" option from your filters, improving both performance and user experience.

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

Why Would You Want to Remove the "All" Option?

Before diving into the "how," it's helpful to understand the "why." Removing the "All" value from a Tableau filter isn't just an aesthetic choice, it solves several practical problems:

• Improved Performance: If a filter controls a view with millions of records, selecting "All" can trigger a massive, slow-running query. Forcing a user to select a specific region, category, or time period can keep your dashboards snappy and responsive.
• Guided Analytics: Sometimes, a dashboard is designed to compare specific items. For instance, you might want a user to compare two products side-by-side, but never see all 5,000 products at once. Removing "All" forces users to make a deliberate choice, guiding them through the analysis as you intended.
• Better User Experience (UX): In some cases, showing data for "All" is meaningless. If your dashboard shows the details of a single customer support ticket, allowing a user to select "All" from a Ticket ID filter doesn't make logical sense. Preventing this choice simplifies the interface and reduces confusion.
• Simplified UI: Let’s be honest - sometimes it just looks cleaner. Removing extra options that users don't need simplifies the interface and puts the focus squarely on the important choices.

Now, let's get into the practical methods for achieving this.

Method 1: Hiding "All" with the "Customize" Option

The simplest way to remove the "All" option is by using Tableau’s built-in filter customization settings. This method works well for multiple-value and single-value list filters, but it might not be available or ideal for every filter type.

This is your best starting point, as it requires no calculations or workarounds.

Step-by-Step Instructions:

1. Add Your Filter: Drag the dimension you want to use as a filter (e.g., [Region]) onto the Filters card in your worksheet.
2. Show the Filter: Right-click the dimension on the Filters card and select Show Filter. You should now see the filter control on the right side of your view.
3. Access the Customize Menu: Click the small dropdown arrow at the top right corner of the filter card. In the menu that appears, hover over Customize.
4. Uncheck "Show 'All' Value": In the Customize context menu, you'll see an option for Show "All" Value. It will be checked by default. Simply click it to uncheck it.

That's it! The "(All)" option will instantly disappear from the top of your filter list. Users can still select multiple items by using the checkboxes (if it’s a multiple-value list), but the one-click option to show everything is gone.

When to use this method: Use this whenever you want a straightforward way to remove "All" from a multi-select or single-select list. It's the cleanest and most direct approach, especially when you don't need to force the user to pick only one item.

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

Method 2: Using Parameters to Force a Single Selection

What if you want to not only remove "All," but also force the user to make a single, specific selection? The customize option might not fit this scenario perfectly. For example, in a multi-select list, a user can still deselect everything, leaving a blank view. By using a parameter, you gain complete control and can ensure one value is always selected.

This approach replaces the filter with a parameter, which gives you more control but requires a bit more setup with a calculated field.

Step-by-Step Instructions:

Step 1: Create the Parameter

1. In the Data pane on the left, click the small dropdown arrow next to the search bar and select Create Parameter.
2. Name your parameter something intuitive, like Select a Region.
3. Set the Data type to match the dimension you're filtering (e.g., String for Region, Integer for Order ID).
4. Under Allowable values, select List.
5. Instead of typing out the values yourself, click Add values from. In the dialog, choose the dimension field that contains your filter values (e.g., Region). This will populate the list automatically.
6. Crucially, do not add an "All" value to this list.
7. Optionally, set a default value in the Current value field to prevent the view from being blank when first loaded. Then, click OK.

Step 2: Show the Parameter Control

Once created, the parameter will appear at the bottom of the Data pane. Right-click on it and choose Show Parameter. It will appear on your sheet view, looking very much like a single-select filter but without an "All" option.

Step 3: Link the Parameter to Your View with a Calculation

The parameter doesn't do anything on its own yet. You need to tell Tableau how to use it with a calculated field that will act as your actual filter.

1. Create a new calculated field. Let's call it Region Parameter Filter.
2. The formula is a simple boolean comparison:

[Select a Region] = [Region]

This calculation checks each row of your data. If the value in the [Region] column matches the region currently selected in your [Select a Region] parameter, it returns TRUE. Otherwise, it returns FALSE.

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

Step 4: Apply the Calculated Field as a Filter

1. Drag your new calculated field (Region Parameter Filter) from the Data pane onto the Filters card.
2. A filter dialog box will appear. Select True and click OK.

Now, your worksheet is filtered to only show data where the calculation is true—that is, where the data matches the value selected in the parameter. Since your parameter has no "All" option and has a default value, the user is effectively forced to view a single region at a time, and the "All" option is nowhere to be found.

When to use this method: This is a powerful technique for high-performance dashboards, as it prevents users from running slow, overarching queries. It’s also perfect for guided analytics where a single selection is required for the view to work correctly.

A key limitation to note: By default, parameters are static. If new regions are added to your underlying data, you must manually go back and update the parameter’s list of values. Newer versions of Tableau have introduced some dynamic capabilities, but it's a historic limitation to be aware of.

Method 3: Obscuring "All" With a Floating Blank Object

Sometimes you need a solution that's quick, simple, and doesn't involve calculations. Perhaps you're using a filter type where the customize option isn’t available, or you're just in a hurry. This visual "hack" isn't the most elegant, but it works in a pinch.

The idea is to simply cover up the "(All)" text on your dashboard with a blank object.

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

Step-by-Step Instructions:

1. First, make sure your filter is set up on a worksheet and looks like a normal list (e.g., Multiple Values List). The "(All)" option should be visible at the top.
2. Add your worksheet containing the visualization and the filter to a Dashboard.
3. From the Objects panel on your dashboard's left sidebar, drag a Blank object onto your dashboard. Be sure to make it a floating object, not tiled. You can switch an object from tiled to floating by selecting it and using its dropdown menu.
4. Resize and position the blank floating object so it sits directly on top of the "(All)" text in your filter list.
5. To make it invisible, select the floating object, go to the Layout panel, and set its background color to match your dashboard's background color. Also, remove any borders.

The result is a filter that appears to start with your first actual value. Users can't see the "All" text, and they can't click what they can't see.

When to use this method: This is a last-resort option. It's technically brittle—if you resize the dashboard or the filter card expands, your floating object can become misaligned, revealing the text underneath. Use this for quick mockups or dashboards that won't be edited frequently, but always prefer Method 1 or 2 for robust, production-level solutions.

Final Thoughts

Removing the "(All)" option from a filter in Tableau is a simple change that can have a big impact on your dashboard's usability and performance. Whether you use a quick customization toggle, a powerful parameter control, or a simple visual trick, you now have the tools to fine-tune your user experience and guide users to the most valuable insights.

Manually tuning filters and perfecting calculations in tools like Tableau is a detailed process that often requires a lot of adjustments. That careful work is essential for building a great analysis, but getting to that starting point can be a slow process. That’s why we created Graphed. We automate the initial busywork by allowing you to create entire dashboards using simple, natural language. Instead of clicking through menus to build your views, you can just ask, "Show me sales by region for the last quarter," and we connect to your live data and build the visualization in seconds, freeing you up to focus on the insights, not the setup.