How to Show and Hide Sheets in Tableau Dashboard

Want to make your Tableau dashboards feel less like a static report and more like an interactive application? A fantastic way to do this is by giving your users the power to choose what they see. This guide will walk you through, step-by-step, how to dynamically show and hide different worksheets on your dashboard using a simple parameter control.

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 Bother Showing and Hiding Sheets?

Before jumping into the "how," let's quickly cover the "why." Allowing users to switch between different views on a single dashboard offers significant benefits, making your reports far more effective and user-friendly.

Here are a few reasons this technique is so popular:

• Saves Prime Real Estate: Dashboards can get cluttered fast. Instead of cramming five different charts onto one screen or forcing users to navigate between multiple dashboards, sheet swapping lets you use the same space for different visualizations. It's like having a one-bedroom apartment with a living room that can transform into a kitchen or an office with the flip of a switch.
• Creates a Cleaner User Interface: A clean, focused dashboard is easier to understand. By showing only one view at a time, you guide the user's attention. They can then choose to see a different view when they're ready for it, preventing overwhelm.
• Provides a Guided Analytics Experience: You can use sheet swapping to tell a story or guide a user through a specific analytical path. Maybe they start with a high-level KPI overview, then click to see a trend chart, and finally drill down into a detailed table - all in the same dashboard space.
• A More Professional Feel: Interactive dashboards that respond to user input feel more modern and custom-built, elevating your work from a simple report to a genuine analysis tool.

Imagine a marketing dashboard where a stakeholder can toggle between "Campaign Overview," "Social Media Performance," and "Website Traffic Trends" without ever leaving the page. That's the power we're about to build.

The Magic Ingredients: Parameters, Calculated Fields, and Containers

The entire show-and-hide technique boils down to a clever combination of three core Tableau features. Let's briefly demystify each one.

1. Parameter: Think of a parameter as a user input variable. It isn't tied to your data source directly. Instead, it's a placeholder whose value is controlled by the dashboard user. In our case, we'll create a parameter that lets the user pick from a list of options, like "Map View" or "Bar Chart View."
2. Calculated Field & Filter: This is our logic engine. We will use a simple calculated field that returns the current value of the parameter. We then apply this calculated field as a filter to each of our worksheets. By setting up the filter correctly, we tell a sheet, "Hey, you are only allowed to appear if the user has selected your specific view in the parameter."
3. Layout Container: This is the secret sauce that makes the visual trick work. When a worksheet has no data to display (because our filter has hidden it), it effectively becomes empty. By placing all our swappable sheets inside a single layout container in Tableau, any empty sheet will automatically collapse, freeing up the space for the active sheet to be displayed.

Step-by-Step Guide: Building Your First Sheet Swapper

Ready to build it yourself? We'll create a simple dashboard that allows a user to switch between a map of sales by state and a bar chart of sales by product category. Follow along with your own data or the sample Superstore dataset that comes with Tableau.

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 1: Build Your Individual Worksheets

Before you can swap sheets, you need sheets to swap! Create the two (or more) separate visualizations you want to toggle between. For this example, we'll create two:

• Sales by State (Map): A simple map visualization that shows the sum of Sales for each state. Double-click the State geographic field, then drag Sales onto the Color card in the Marks pane.
• Sales by Category (Bars): A horizontal bar chart showing the sum of Sales for each Category. Drag Sales to Columns and Category to Rows.

Make sure both sheets are built, named clearly, and ready to go. You haven't added any interactivity yet, but having your base visuals prepared is the essential first step.

Step 2: Create a Parameter for User Selection

Now, we'll create the dropdown menu for our users.

1. In the Data pane (on the left side), click the small dropdown arrow at the top and select Create Parameter….
2. In the dialog box, set up your parameter as follows:
3. Click OK.

You'll now see your new "Select a View" parameter at the bottom of the Data pane. To see it in action, go to one of your worksheets, right-click the parameter in the Data pane, and choose Show Parameter. A dropdown control will appear on the right side of your view.

Step 3: Create a Calculated Field to Control Visibility

Next, we need a simple calculated field that acts as a go-between for our parameter and our filter.

1. Click the dropdown arrow in the Data pane again and select Create Calculated Field…
2. Name the calculation something intuitive, like View Selector.
3. In the formula box, simply enter the name of your parameter:

That's it! This calculated field will always be equal to whatever value is currently selected in your parameter. Click OK.

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: Connect the Parameter to Each Worksheet with a Filter

This is where the logic comes into play. We will now tell each sheet when to appear.

1. Navigate to your first worksheet, the Sales by State (Map) sheet.
2. From the Data pane, drag your new View Selector calculated field onto the Filters shelf.
3. A dialog box will pop up. In the "General" tab, you'll see a list with the options from your parameter. Check the box only for "Map View" and click OK.

You have just told Tableau: "For this map sheet, you should only activate and show data when the View Selector evaluates to 'Map View'."

Now, repeat the process for your second sheet:

1. Navigate to your Sales by Category (Bars) sheet.
2. Drag the View Selector calculated field onto the Filters shelf.
3. In the dialog box, check the box only for "Bar Chart View" and click OK.

Quick Test: Try changing your "Select a View" parameter on either of the sheets. When you select "Bar Chart View," your map should go completely blank. When you select "Map View," your bar chart should disappear. If this works, you're on the right track!

Step 5: Assemble Your Dashboard in a Layout Container

The worksheets are correctly configured. Now let's arrange them on the dashboard so they seamlessly swap in and out.

1. Create a new dashboard by clicking the "New Dashboard" icon at the bottom.
2. From the Objects panel on the left, drag a Vertical Layout Container onto the blank dashboard canvas. Objects inside this container will stack on top of each other. (A horizontal container works too, but they would appear side-by-side).
3. Now, drag both your worksheets (Sales by State map and Sales by Category bars) into this container. You should see a blue border around the container when you are dragging the sheets over it.
4. After both sheets are in the container, click the "Select a View" parameter dropdown on the dashboard and toggle between the options. You'll notice that the sheets appear and disappear, but a lot of blank white space remains for the hidden sheet. We need to fix that.
5. For each worksheet in the container, click its small dropdown arrow (on the top right of the sheet's border) and ensure the option "Fit to entire view" or a similar fit is selected.
6. This is the most crucial step: hide the titles. Right-click on the title of your map sheet ("Sales by State") and select "Hide Title." Do the same for your bar chart sheet's title. If you leave the titles visible, they'll remain on the screen even when the worksheet content vanishes, breaking the illusion.

Now, test your dashboard! When you change the parameter value, the inactive sheet should completely disappear, allowing the active sheet to take up the full space of the container. Success!

Advanced Tips and Best Practices

You've mastered the basic technique! Here are a few ways to take your sheet swapping to the next level.

Create a Dynamic Title

Since you had to hide the individual sheet titles, you can create a single dynamic title that updates based on the selected view.

1. Create a new blank worksheet and name it Dynamic Title.
2. Drag your View Selector calculated field onto the Text card in the Marks pane.
3. Click on the Text card, then the ... button to edit the label. Format the text to be centered and in a larger, bold font so it looks like a title.
4. On your dashboard, drag this new Dynamic Title sheet into the container at the very top. Hide its title just like you did with the others.

Now your label will change from "Map View" to "Bar Chart View" as you toggle the parameter, giving your dashboard a proper, responsive heading.

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

Use "Buttons" Instead of a Dropdown

Dropdown menus are functional, but sometimes dedicated buttons feel more intuitive. You can achieve this using Dashboard Parameter Actions. The setup is a bit more involved but the result is much slicker.

You'd create a new worksheet that acts as a navigation menu (you can even use shape marks to make them look like icons), and then create a Parameter Action that says "When the user clicks on this part of the navigation sheet, update the Select a View parameter with the corresponding value." This triggers the swap just like the dropdown, but with a more custom feel.

Final Thoughts

Mastering the show-and-hide technique with parameters and layout containers is a major milestone in taking your Tableau skills from beginner to enthusiast. It's a simple, powerful way to make your dashboards cleaner, more interactive, and far more engaging for anyone you share them with.

Creating dynamic dashboards in complex tools takes time, especially when you're wrestling with calculated fields, filters, and layout containers. We built Graphed to remove this friction by connecting your marketing and sales data sources in one place and letting you build the dashboards you need just by describing them. Instead of a multi-step manual process, you get a real-time, shareable dashboard in seconds, allowing you to get answers and focus on strategy, not configuration.