Sheet swapping in Tableau lets you dynamically show and hide worksheets in the same dashboard space using a parameter. It saves real estate on a busy dashboard and gives users the choice of how they want to view the data, for example switching between a scatter plot and a bar chart.
This guide walks you through the parameter method in 5 steps, plus the fixes for the issues that always trip people up.
What is sheet swapping in Tableau?
Sheet swapping is a Tableau technique that lets two or more worksheets occupy the same space on a dashboard, with only one visible at a time. The user (or a parameter action) controls which sheet appears, while the others collapse out of view.
The mechanism is straightforward: a parameter changes the value of a calculated field, the calculated field acts as a filter on each worksheet, and any worksheet whose filter returns no rows collapses inside its container. The result is a clean, interactive dashboard.
People sometimes call this "dynamically showing/hiding worksheets in Tableau." It refers to the same technique.
When should you use sheet swapping?
Sheet swapping is worth reaching for whenever dashboard space is tight or you want to give the reader a choice. Common use cases:
- Toggling chart types for the same data, for example a scatter plot vs a bar chart vs a table.
- Cycling through KPIs when each one needs its own chart type (a line for trend, a map for geography, a bar for ranking).
- Mobile and tablet dashboards where vertical space is limited and stacking every view is not an option.
- Whole-dashboard swaps where the user switches between an executive summary view and a detailed analyst view inside the same workbook.
If you only need to toggle between two views and you are on Tableau 2022.3 or later, Dynamic Zone Visibility is often easier.
How to dynamically show/hide worksheets in Tableau in 5 steps
Here is the full parameter-based method. It works in every modern version of Tableau Desktop and supports as many sheets as you want.
Step 1: Create a parameter for your sheets
Right-click in the Data pane and select Create Parameter. Give it a name like p.Sheet Swap and create one allowable value for each sheet you want to swap between.
Tip: use integers for the Value and clear strings for Display As. The Value is what Tableau sees behind the scenes, and the Display As field is what your user sees in the dropdown, so make those labels easy to read ("Bar Chart", "Scatter Plot", "Data Table"). For more on the underlying mechanics, see Tableau's documentation on parameters.
If you ever need a parameter that holds more than one value at once, take a look at our guide on multiple select parameters.
Step 2: Create a calculated field using the parameter
Right-click in the Data pane and select Create Calculated Field. Name it something like Sheet Swap Filter and write a simple formula that references your parameter:
[p.Sheet Swap]
Done. This calculated field will return the current parameter value, and Tableau will use it to decide which sheet shows up. If you want a refresher on calculated field syntax, Tableau's calculated fields guide is a good place to start.
Step 3: Add the calculated field as a filter on each worksheet
Drag Sheet Swap Filter to the Filters shelf on every sheet you want included in the swap. In the filter dialog, select only the value that corresponds to the current sheet. So your bar chart filters to "1", your scatter plot filters to "2", and so on.
Pro tip: if the current parameter value does not match the sheet you are working on, Tableau will not let you tick the right box because that value is not currently "in the data." Force it in via Edit Filter > General > Custom Value List > (type your value) > click + > OK. This saves repeated trips to the parameter control to flip values between sheets.
Step 4: Build your dashboard inside a layout container
Create a new dashboard. Drag either a horizontal or vertical layout container onto the canvas, then drop all of your swappable sheets inside that container.
Two things to do here that are easy to forget:
- Hide the title on every swappable sheet. Right-click the title and choose Hide Title. Filters do not affect sheet titles, so if you skip this step you will end up with a phantom title sitting where your collapsed sheet used to be.
- Do not fix the size of the container or the sheets inside it. Fixed sizes prevent collapsed sheets from giving up their space, which defeats the whole point.
If you want to give your final dashboard an extra layer of polish, our post on parameter actions shows how to let users swap sheets by clicking on icons rather than using a dropdown.
Step 5: Show the parameter control
Click the dropdown arrow on any sheet in your dashboard, hover over Parameters, and select your sheet swap parameter. The control will appear on the dashboard.
.png)
Now switch the value. The sheets should swap.
Troubleshooting: why isn't my Tableau worksheet hiding?
Sheet swapping is one of those Tableau features that works perfectly once you know the rules and refuses to budge before then. Here are the three issues that catch almost everyone.
Problem: The worksheet stays visible even though the filter is working.
Fix: Check whether the worksheet or its container has a fixed size. In Step 4 we put everything inside a layout container so the sheets can resize each other freely. If you set a size limit (right-click the sheet on the dashboard and check the size setting), Tableau cannot collapse the sheet to zero, so it sits there empty instead.
Problem: The sheet hides, but the title remains.
Fix: Worksheet filters do not apply to titles. You need to manually hide the title on every swappable sheet by right-clicking it and selecting Hide Title.
Problem: My bubble chart or pie chart will not hide, even though everything else is set up correctly.
Fix: Gridless chart types, the ones that have no pill on Rows or Columns, do not collapse properly because Tableau has nothing to anchor the filter to. Add a blank pill to one of the shelves to give it something to grab onto. Type "" directly into Rows or Columns, then right-click and choose Hide Header. The chart looks the same but now it behaves like every other view.
Frequently Asked Questions
What does sheet swapping mean in Tableau?
Sheet swapping is a technique where two or more worksheets share the same dashboard space, and only one is visible at a time. A parameter controls which sheet shows, and the others collapse using a filter. It is the standard way to save dashboard space while still giving users a choice between chart types or views.
Why is my Tableau worksheet not hiding when I sheet swap?
The three most common causes are a fixed worksheet or container size (which prevents the sheet from collapsing), an unhidden sheet title (which the filter cannot affect), and gridless chart types like bubble or pie charts with no pill on Rows or Columns. Fixing any one of these usually solves the issue.
Can I dynamically show or hide more than two worksheets in Tableau?
Yes. The parameter method scales to as many sheets as you want. Add one allowable value to the parameter for each sheet, then apply the calculated field filter on every worksheet, selecting the value that matches. Some dashboard builders use this to swap five or more views in a single container.
Should I use sheet swapping or Dynamic Zone Visibility?
Use Dynamic Zone Visibility (Tableau 2022.3+) for simple two-sheet toggles where you also want filters and legends to come along automatically. Use parameter sheet swapping when you need to swap three or more sheets, work in older Tableau versions, or swap entire grouped sections of a dashboard.
.avif)
.avif)
