How to Hide Filters in Tableau

Cody Schneider8 min read

Hiding filters in Tableau might seem like a small detail, but it’s one of the best ways to elevate your dashboards from cluttered to clean and from confusing to intuitive. This isn’t just about making things look nice, it’s about creating a guided, user-friendly experience that helps people find the insights they need without getting overwhelmed. This article will show you several techniques for hiding and revealing filters, from a simple button click to dynamic, collapsible menus.

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 Bother Hiding Filters in Tableau?

Before we jump into the "how," let's quickly cover the "why." Controlling filter visibility is a core skill for building professional-grade dashboards. Here's what it helps you achieve:

  • Saves Prime Dashboard Real Estate: Dashboards are often packed with information. Tucking away a panel of 5-10 filters until they’re needed frees up a significant amount of space, allowing your charts and KPIs to be the main focus.
  • Improves the User Experience (UX): A clean, uncluttered interface is less intimidating for users. By starting with a simple view and allowing users to reveal filters when they want to dig deeper, you create a more guided and less stressful analytical experience.
  • Creates Guided Analytics Paths: You can strategically reveal certain filters only after a user has made a selection elsewhere. This guides them through a logical analysis process - for instance, showing a 'City' filter only after a 'State' has been chosen.
  • Enhances Dashboard Interactivity: Modern web design has taught users to expect interactive elements. A sleek, collapsible filter menu makes your dashboard feel more responsive and professional, similar to a web application.

Method 1: The Simple Show/Hide Button for Containers

Tableau has a built-in feature that’s perfect for a straightforward, all-or-nothing approach to hiding a filter panel. If you just want a single button that makes a group of filters appear or disappear, the 'Add Show/Hide Button' feature on a layout container is your first great option.

This works best when you have all your filters grouped into one dedicated section, like a sidebar.

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.

How to Set It Up:

  1. Group Your Filters in a Container: On your dashboard, drag either a Vertical or Horizontal layout container onto the canvas. Now, drag each of your filter cards into this container. This groups them into a single object. Pro-tip: You can select the container itself by clicking once on any item inside it (like a filter) and then clicking the gray handle that appears at the top.
  2. Add the Show/Hide Button: Once the container is selected, click the small dropdown arrow that appears in its top-right corner. From the menu, select Add Show/Hide Button.
  3. Position and Customize the Button: Tableau will automatically place a small button object on your dashboard. You can drag this button anywhere you like. To change how it looks, select the button, click its dropdown arrow, and choose Edit Button... Here you can:

To see it in action, hold down the ALT key (or Option on Mac) and click the button while in a sheet. In Presentation Mode, you can just click it directly. The entire container with all your filters will appear or disappear with a single click. Quick, easy, and effective.

Method 2: Building a Dynamic Collapsible Filter Menu

The built-in show/hide button is great, but it has a limitation: when the panel disappears, it leaves behind an empty space. A more advanced technique is to create a filter pane that truly collapses, allowing your charts and other dashboard elements to expand and fill the newly available space. This is done using a parameter and a "spacer" worksheet.

It takes a few more steps, but the result is a much sleeker and more professional dashboard.

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

Step-by-Step Instructions:

1. Create a Control Parameter

First, you need a way for the user to toggle the filter visibility. A parameter is perfect for this.

  • Go to the data pane, click the small dropdown arrow, and select Create Parameter.
  • Name it something like "Show Filter Panel?".
  • Set Data type to Boolean.
  • For Aliases, you can change 'True' to 'Show' and 'False' to 'Hide' for clarity.
  • Click OK. Right-click the new parameter in the data pane and select "Show Parameter" to add it to your current view for now so we can test it. You can hide it on the final layout.

2. Create a "Blank" Spacer Worksheet

This is the secret ingredient. We're going to create a worksheet that will either take up space or completely disappear based on our parameter's value.

  • Create a new worksheet. Let’s name it "Spacer."
  • Next, click on the Dropdown arrow in the Data pane and hit “Create Calculated Field“. Create a dummy calculated field named Calculated True simply write TRUE. Then drag it onto the “Filters“ card. Select True then OK. This gives you a blank sheet.
  • Click on the Dropdown arrow in the Data pane again and hit ”Create Calculated Field” again. Create another calculated field named Panel state trigger in the editor window write your newly created parameter Show Filters Panel. Next, drag this Panel state trigger calculated field into the Filter Pane/Card on the “Spacer” Sheet. Check True and hit OK.
  • Finally, right-click on this “Filter” and select Apply to Worksheets then "Selected worksheet". And make sure this filter will only manipulate your “Spacer” Sheet. This makes the sheet 'disappear' when the parameter is set to 'False.'

3. Assemble the Dashboard Layout

The layout structure is crucial for this technique to work.

  • Drag a Horizontal layout container to your dashboard. This will hold both your filter menu and your main charts.
  • Drag a Vertical layout container inside the horizontal container to the far left. Drag all of your filter cards into this vertical container. Give this filter container a fixed width so you can control its space on screen. Simply click the vertical layout container's dropdown menu in the upper right-hand corner and select “Set width…” Try to set a width that you feel comfortable with, perhaps 250px. Next, drag your "Spacer" sheet into the horizontal container, placing it to the right of your filter panel's vertical container.
  • Remove the title from the "Spacer" sheet by right-clicking its title on the dashboard and choosing Hide Title.
  • Drag your primary dashboard content (your chart or another container with your charts) into the horizontal container to the right of the Spacer sheet so they take up the remaining space on your dashboard. Once you do that, simply play around selecting Fit “Entire View” with the space sheet or the chart on the dashboard you put beside it inside of the Horizontal Layout Container.

Now, try toggling your "Show Filter Panel?" parameter control. When it’s set to 'True,' the spacer sheet appears next to your filter panel, allocating it screen space. But flip that parameter to 'False,' the “Spacer Sheet” gets filtered out and because now it has no data it disappears. This removes this Spacer Sheet completely from the visualization, which will allow your chart beside it to 'gain back' the pixels of space no longer being occupied by the Spacer Sheet.

Method 3: Conditionally Hiding Irrelevant Filter Options

Sometimes you don't need to hide the entire filter card, but rather the irrelevant options within it. Imagine a user filters by 'Country'. You wouldn't want the 'City' filter to still show cities from every country in the world. Instead, it should update to only show cities from the selected country. This makes the user's choices more manageable and the dashboard feel smarter.

Tableau makes this easy with Context Filters and the "Only Relevant Values" option.

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.

How it Works:

  1. Identify the Hierarchy: Determine which filter is the "parent" (e.g., Region) and which is the "child" (e.g., State).
  2. Add the Parent to Context: On your dashboard, find the parent filter card (e.g., 'Region'). Click its dropdown arrow and select Add to Context. You'll notice the filter pill turns gray on the Filters shelf. Context filters are high-priority filters that execute before all other non-context filters on the worksheet.
  3. Set the Child to Show Relevant Values: Now, find the child filter card (e.g., 'State'). Click its dropdown arrow. In this menu, choose the option Only Relevant Values.

That's it! Now, when a user selects a value in the 'Region' filter, the 'State' filter will automatically update to display only states inside that region you just specified. This dynamic filtering declutters the interface and prevents users from making impossible selections, significantly improving the dashboard's usability.

Final Thoughts

Mastering how to hide and show filters is what separates good dashboards from great ones. Whether you're using a simple show/hide button for quick clean-up, a dynamic collapsible menu for a professional feel, or context filters for a smarter user experience, controlling what your user sees gives you the power to create more effective and intuitive dashboards.

Building these types of advanced, user-friendly interactions in traditional BI tools often takes practice and a lot of manual configuration. At Graphed, we created a way to skip the complicated setup entirely. When you connect your data, you can simply ask in plain English to build dashboards with interactive components like these. By describing what you want to see - "create a dashboard of sales by region and make a collapsible menu for all the filters" - we instantly generate a real-time dashboard that handles the technical parts for you, letting you focus on answering questions with your data, not wrestling with design settings.

Related Articles