How to Hide Dashboard in Tableau

Showing a dashboard in Tableau is easy, but hiding one is where the real design and user experience magic happens. Controlling which sheets and dashboards users see is essential for creating clean, guided analytical experiences and securing sensitive data. This article will guide you through several methods for hiding dashboards and worksheets in Tableau, from simple publishing options to more dynamic, user-driven techniques.

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 Hide a Tableau Dashboard or Worksheet?

Before jumping into the "how," it's helpful to understand the "why." Hiding specific elements in your Tableau workbook isn't just about tidying up, it serves several strategic purposes:

• Improve User Experience (UX): A workbook crowded with dozens of tabs can overwhelm users. By hiding helper sheets, drafts, or detailed views, you can present a clean, focused interface that directs users to the most important insights.
• Create a Guided Journey: Often, you want to guide a user through a specific analytical path. This starts with a high-level overview and then allows them to drill down into details. Hiding the detail-level dashboards and revealing them only through specific actions (like clicking a button) creates a controlled, intuitive flow.
• Secure Sensitive Information: Not every user should see every piece of data. Hiding entire dashboards or filtering the data within them based on user credentials is a critical part of data governance and security.
• Separate Views for Different Audiences: An executive might only need a KPI summary dashboard, while a data analyst needs ten different detailed views to explore. Hiding dashboards allows you to serve multiple audiences from a single workbook.

Method 1: The Easiest Way to Hide All Tabs on Publish

The simplest way to control what users see is to hide the navigation tabs at the top of the view when you publish your workbook to Tableau Server or Tableau Cloud. This is the best approach when you want to build a self-contained, app-like experience where navigation happens exclusively through buttons or action filters you’ve created on the dashboards themselves.

When you hide the tabs, users will only see the default dashboard or sheet you published. They cannot freely navigate to other hidden worksheets or dashboards unless you provide a button or link for them to do so.

Here’s how to do it:

1. From your finished workbook in Tableau Desktop, go to the top menu and select Server > Publish Workbook.
2. Connect to your Tableau Server or Tableau Cloud account if prompted.
3. In the "Publish Workbook" dialog box, you'll see a section for "More Options." Within that, look for "Show sheets as tabs."
4. Uncheck the box next to "Show sheets as tabs."
5. Configure any other settings, like permissions or data source scheduling, and click Publish.

Now, when users open the workbook online, they'll see a clean view without any navigation tabs at the top. This forces them to interact with the dashboard as you designed it, using the navigation buttons you built to move between the summary dashboard and any hidden detailed dashboards.

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: Dynamically Hide Worksheets with Sheet Swapping

Sometimes you don't want to hide an entire dashboard, but rather show or hide specific worksheets within a single dashboard. This is perfect for when you want to let the user switch between different chart types (like a Bar Chart and a Line Chart of the same data) or view different metrics in the same space. This technique is called "sheet swapping."

It involves a Parameter and a Calculated Field to control which sheet is visible inside a layout container.

Step 1: Create a Parameter

The parameter will be the control that your user interacts with, like a dropdown menu.

• In the Data pane, click the down arrow and select Create Parameter.
• Give it a descriptive name, like "Select a View."
• For Data type, choose String.
• Under Allowable values, select List.
• In the list of values, type the names of the views you want to offer. For example: "Sales Trend" and "Profit by Category."
• Click OK.

Step 2: Create a Calculated Field to Link to the Parameter

This calculated field will act as the filter control for each worksheet.

• Click the down arrow in the Data pane and select Create Calculated Field.
• Name it something like "View Selector."
• The formula is incredibly simple - it's just the name of your parameter:
• Click OK.

Step 3: Apply the Filter to Each Worksheet

Now, you need to tell each worksheet when it should appear.

1. Go to your first worksheet (e.g., the "Sales Trend" sheet).
2. Drag your "View Selector" calculated field onto the Filters shelf.
3. A filter dialog box will appear. Select the Custom value list tab.
4. Click the "+" symbol and type the exact name you used in your parameter's value list (e.g., "Sales Trend").
5. Click OK.
6. Repeat this process for your other worksheet (e.g., "Profit by Category"), but this time set the filter value to "Profit by Category."

Now, if you show the parameter control (right-click your "Select a View" parameter and choose "Show Parameter"), you'll see that when you select "Sales Trend," only the sales trend worksheet has data. The other sheet becomes blank.

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: Assemble the Dashboard

The final step is to put the sheets into a single container on a dashboard so they appear to swap in the same position.

1. Create a new dashboard.
2. From the Objects pane, drag a Vertical or Horizontal container onto your dashboard canvas.
3. Drag both of your worksheets (e.g., "Sales Trend" and "Profit by Category") into this container.
4. For the magic to work, you must hide the titles of each worksheet. Click the dropdown menu for each sheet in the container and select Hide Title.
5. Finally, right-click your "Select a View" parameter in the Data pane and select Show Parameter.

Now, when you select a view from the parameter dropdown, one sheet's content will disappear, and the other will take its place, creating a seamless swapping effect. You’ve successfully hidden one sheet while showing another, all within the same dashboard space.

Method 3: Conditionally Hide Data with User Filters (Row-Level Security)

This method is less about hiding the physical dashboard tab and more about hiding the data within it based on who is logged in. This is the foundation of row-level security (RLS) in Tableau and is critical for data governance.

The goal is to ensure a user viewing a dashboard can only see the data rows relevant to them (e.g., a regional manager only sees sales data for their region).

The most robust way to do this is with a dynamic user filter.

Prerequisite: Create a User Mapping in Your Data

Your data source must contain a column that identifies which user should be able to see which row. This is typically an email address, a user ID, or a group name. For example, if you have sales data, you might have a column named Salesperson_Email.

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

How to Create a Dynamic User Filter

1. Connect to your data source in Tableau Desktop.
2. Create a calculated field. Let's call it "User Filter."
3. The formula checks if the currently logged-in Tableau user's username matches the username in your data. The functions for this are USERNAME() or USERDOMAIN_PLUS_USERNAME().

The formula would look like this:

USERNAME() = [Salesperson_Email]

This calculation will return True if the usernames match and False otherwise.

1. Drag this new "User Filter" calculated field to the Filters shelf on every relevant worksheet.
2. In the filter dialog, check the box for True and click OK.

That's it. Now, when you publish this workbook, Tableau will automatically filter the dashboard for each user who logs in. If their username doesn't appear in the [Salesperson_Email] column for a given data row, that row is effectively hidden from them. For users who shouldn't see any data on a particular dashboard, the entire dashboard will simply appear blank.

Final Thoughts

Hiding dashboards and sheets in Tableau is all about creating a better, more secure user experience. Whether you're unchecking the "Show sheets as tabs" box to build a guided app, using parameters for dynamic sheet swapping, or implementing user filters to secure data, these techniques will elevate your dashboards from simple charts to professional-grade analytical tools. Master these methods, and you'll have greater control over how your audience interacts with their data.

While Tableau provides powerful manual customization, we understand that building these intricate guided experiences often requires deep tool-specific knowledge and time. At Graphed, we aim to deliver those insights without the steep learning curve. We created our platform so you can build and customize dashboards just by describing what you need in plain English. Instead of grappling with containers and calculated fields, you can instantly get the exact report you need, making it faster to move from raw data to actionable insights.