Tableau Dynamic Zone Visibility

Dynamic Zone Visibility in Tableau allows you to show or hide dashboard elements dynamically based on user interaction, eliminating cluttered containers and complex sheet-swapping hacks. Here is a walkthrough using a basic example with the superstore dataset to construct a dynamic drill-down dashboard that reveals detailed customer sales only when a region is selected.

1. Create the Calculation and Parameter

• Boolean Parameter: Create a parameter named Sheet Visibility with a boolean data type (true/false).
• Calculated Field: Create a calculated field named Always Visible with the static formula TRUE.

2. Build the Core Worksheets

• Sheet 1 (Sales by Region): For your sheet you want to stay visible place your Always Visible field onto the details mark.
• Sheet 2 (Customer Sales Table): For your second sheet you don't need to do anything special.

3. Apply Dynamic Zone Visibility on the Dashboard

• Combine Sheet 1 and Sheet 2 onto a dashboard.
• Select Sheet 2 on the dashboard canvas and open the Layout tab on the left panel.
• Check the box labelled Control zone visibility using value.
• Choose Sheet Visibility from the dropdown list as the controlling parameter.

4. Wire Up Dashboard Actions

• Parameter Action: Go to Dashboard > Actions and add a Change Parameter action. Set the source sheet to Sheet 1 on Select. Target the Sheet Visibility parameter using the Always Visible source field. Under Clearing the selection, set the option to Set value to and select False.
• Filter Action: Add a Filter action that targets Sheet 2 using Sheet 1 as the source.

How It Operates Clicking any bar on our Sheet 1 view triggers the parameter action, setting Sheet Visibility to True and making the Sheet 2 pane appear while simultaneously filtering it to the chosen region. Deselecting the bar resets the parameter to False, causing the detailed view to collapse seamlessly.