How to Remove All Options in Tableau Filter

That little "(All)" option at the top of a Tableau filter seems helpful, but it can often clutter your dashboard and confuse your users. Sometimes, you need people to look at one thing at a time to see the real story. This guide will walk you through a couple of quick methods to remove the "(All)" option, giving you more control over how people interact with your data.

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 Anyway?

Before jumping into the "how," let's quickly cover the "why." Removing the universal "All" from a filter isn't just about aesthetics, it's about creating a more deliberate and effective user experience. Here are a few common reasons to do it:

• To Improve Clarity and Readability: Imagine a line chart showing daily sales for every single product in your inventory at once. It would look like a plate of spaghetti - a confusing mess where no single trend is visible. Forcing a user to select a single product or category makes the chart clean, readable, and instantly insightful.
• To Guide the User's Analysis: As the dashboard creator, you have a story you want to tell. By removing the "All" option, you encourage users to drill down into specific segments. You’re prompting them to ask questions like, "How did this specific marketing campaign perform?" instead of leaving them with a giant, aggregated number that hides the details.
• To Boost Dashboard Performance: When a user first opens a dashboard and a filter is set to "All," Tableau has to query and render data for every single value in that dimension. On large datasets, this can translate to slow load times and a frustrating user experience. Forcing a single, default selection means an initial view loads lightning-fast.

In essence, it’s about control. You gain control over the narrative, the initial view, and the dashboard's performance.

Method 1: The Quick-and-Easy "Customize" Option

This is the most direct way to hide the "(All)" value and it takes less than 30 seconds. It’s perfect when your only goal is to remove the option without adding complex logic.

Let's use a common example: you have a dashboard showing sales performance, and you've added a filter for "Product Category." By default, it includes "(All)." Here's how to get rid of it.

Step-by-Step Instructions:

1. Show the Filter: First, ensure your filter is visible on your dashboard or worksheet. If you haven't yet, drag your dimension (e.g., "Product Category") to the Filters card. Then, right-click on the pill in the Filters shelf and select Show Filter.
2. Edit the Filter Card: Look at the filter card that has appeared in your view. You’ll see a small dropdown arrow (a downward-facing triangle) in the top-right corner of the card. Click it.
3. Find "Customize": In the context menu that appears, hover your cursor over the Customize option. This will reveal another sub-menu.
4. Deselect “Show 'All' Value”: In this sub-menu, you’ll see several checkboxes. Simply click on the one that says Show "All" Value to uncheck it.

And that's it! The "(All)" option will instantly disappear from your filter.

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

What Happens Next?

Once you remove the “(All)” option, Tableau will automatically select the first value in your filter’s list as the default. This is important to remember. If the first item alphabetically is "Accessories," every user landing on your dashboard for the first time will see data for Accessories. If you want a different default value, simply select it yourself inside the filter and save the workbook. That way, the dashboard opens with the most relevant view you want people to see first.

Best for: Situations where you simply want to clean up the UI and prevent users from selecting everything at once, but you're okay with them still being able to select multiple (but-not-all) options at a time (if you’re using a multi-select list).

Method 2: Gaining Full Control with a Parameter

Sometimes, just removing "(All)" isn't enough. You might want to force the user to only select one option. A user shouldn't be able to compare "Books" and "Electronics" at the same time, they must choose one or the other. In this case, hiding "(All)" doesn't solve the core problem if you're using a multiple-value list filter. This is where parameters shine.

A parameter is essentially a dynamic placeholder that users can control. We can create a parameter that lists all our product categories and then use a calculated field to filter the view based on the user's selection. This approach replaces the default filter entirely.

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 1: Create the Parameter

First, we need to create a list that the user will choose from.

1. In the Data pane (on the left side of your screen), right-click in an empty area and select Create Parameter.
2. A configuration window will pop up. Fill it out as follows:
3. Click OK.

You’ve now created the parameter! To make it visible, right-click on your new parameter in the Data pane ("Select a Product Category") and choose Show Parameter.

You'll see a user-friendly dropdown on your sheet, but it won’t do anything just yet. We need to tell Tableau how to use it.

Step 2: Create the Calculated Field to Link the Parameter

A parameter is just a spectator until a calculated field gets it involved in the action. We'll create a simple true/false calculation to act as our filter logic.

1. Right-click in an empty space in the Data pane again, but this time, select Create Calculated Field.
2. Name this calculation something that makes sense, like "Category Filter Logic."
3. In the formula box, type the following simple formula:

[Product Category] = [Select a Product Category]

This formula is elegantly simple. It looks at every row of your data and asks, "Does the value in the 'Product Category' column match the value the user just chose in our 'Select a Product Category' parameter?" It will return "True" if they match and "False" if they don't.

Click OK to save the calculated field.

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 3: Apply the Calculated Field as a Filter

Now, we’ll use our "True/False" calculation to actually filter the data on the view.

1. Find your calculation ("Category Filter Logic") in the Data pane.
2. Drag it and drop it directly onto the Filters shelf.
3. A small dialogue box will appear, asking you which values you want to filter for. You'll see options for "True" and "False."
4. Check the box for True and click OK.

That's it! Your view is now controlled entirely by the parameter. When a user selects a category from your parameter dropdown, the "Category Filter Logic" returns "True" for that data, and your sheet filters to show only that information. There is no "(All)" option, and the user is forced into making a single selection, creating a much more controlled and focused analytical experience.

Best for: Dashboards where a single selection is critical for clarity or performance, and when you want that single selection to potentially influence multiple worksheets or complex calculations at the same time.

Best Practices for a Better User Experience

Simply removing the filter option is a technical fix, but a truly great dashboard thinks about the user's perspective. Here are a few tips:

• Explain the Interaction: If you're using the parameter method to force a single selection, use clear titles. A simple header above your parameter like "Please select a category to view details" removes any guesswork for the user.
• Set a Sensible Default: Whether you’re using Method 1 or 2, your dashboard will have a default starting view. Make sure it's a useful one. Perhaps it’s your most popular product category, the current month, or a company-wide KPI view. Don't leave your users on an empty or obscure category by default.
• Consider the Context: Resist the urge to universally remove the "(All)" option just because you can. Ask yourself, "Is there any valid reason my user might want to see the total aggregated view?" On a summary dashboard, seeing the overall total is often the entire point. Save this technique for detail-oriented views where drilling down is the goal.

Final Thoughts

Knowing how to remove the "(All)" option is a great skill to have in your Tableau toolkit. The "Customize" function is a quick and effective fix for cleaning up your user interface, while using parameters provides a more robust solution for strictly guiding users to make a single, specific choice. Choose the method that best aligns with the story you’re trying to tell with your data.

Ultimately, the goal is always to create cleaner, faster, and more intuitive reports. We built Graphed on the same principle of making complex data analysis effortless. Instead of spending your time tweaking filter logic or writing calculated fields, you can just ask questions in plain English, like "Show me a dashboard of daily sales by product category for this quarter," and have a fully interactive dashboard built for you in seconds.