Master Tableau From Scratch

Learn Tableau fundamentals, data connections, data preparation, filtering, data modeling, calculations, LOD expressions, visualizations, dashboards, and storytelling through structured practical lessons.

COURSE SYLLABUS

Dynamic Visibility in Tableau

Learn how to control the visibility of dashboard objects dynamically using parameters, calculated fields, and Dynamic Zone Visibility. Create cleaner dashboards with interactive content that appears according to user selections.

1. What is Dynamic Visibility in Tableau?

Dynamic Visibility in Tableau allows dashboard authors to control whether specific dashboard zones or objects are displayed based on defined conditions. Instead of displaying every visualization at the same time, a dashboard can show selected content when a user interacts with a control.

For example, a sales dashboard may contain a detailed regional map and a product performance chart. Users can select an option to display the required visualization while keeping the dashboard organized.

Important: Dynamic Zone Visibility is a Tableau dashboard feature that controls the visibility of supported dashboard layout containers based on a Boolean field or parameter condition. It is different from simply filtering the data displayed in a chart.

Why Use Dynamic Visibility?

  • Reduce unnecessary dashboard content.
  • Display information based on user requirements.
  • Create interactive dashboard experiences.
  • Organize multiple views in a limited dashboard area.
  • Make complex dashboards easier to navigate.
  • Provide different analytical views from one dashboard.

2. Understanding Dynamic Zone Visibility

Dynamic Zone Visibility allows a dashboard zone to appear or disappear based on a Boolean condition. The condition can be controlled through a parameter or a calculated field.

A dashboard author can configure a supported layout container to be visible only when the controlling field evaluates to TRUE.

Basic Working Concept

  1. Create a parameter or calculated field.
  2. Configure the field to return TRUE or FALSE.
  3. Add the required dashboard objects inside a supported layout container.
  4. Open the container's Layout settings.
  5. Enable control of visibility using the selected field.
  6. Test the dashboard by changing the parameter or condition.
Example: A dashboard contains a Sales Chart container. When the Show Sales parameter is TRUE, the container is displayed. When the parameter is FALSE, the container is hidden.

3. Dynamic Visibility Workflow

Dynamic visibility follows a simple process. A user changes a parameter or a condition, Tableau evaluates the Boolean value, and the corresponding dashboard zone is displayed or hidden.

User Input Parameter Calculation TRUE / FALSE Visibility Evaluation Dashboard Zone TRUE = Visible | FALSE = Hidden Illustrative Dynamic Zone Visibility process
Figure 1: How Dynamic Zone Visibility works in Tableau.

4. Understanding Boolean Fields

Boolean fields are commonly used to control Dynamic Zone Visibility. A Boolean field returns one of two logical values: TRUE or FALSE.

Boolean Value Meaning Visibility Result
TRUE The condition is satisfied. The configured zone is visible.
FALSE The condition is not satisfied. The configured zone is hidden.

Example Calculated Field

Suppose a parameter named Show Sales Details controls whether a sales detail container should be displayed. A calculated field can directly return the parameter value.

 // Calculated Field: Show Sales Zone

[Show Sales Details]

If the parameter returns TRUE, the container becomes visible. If it returns FALSE, the container is hidden.

Note: The controlling field must return a Boolean value for the visibility configuration. A text or numeric field cannot be used directly as the visibility condition without an appropriate Boolean calculation.

5. Creating a Parameter for Dynamic Visibility

Parameters allow users to control dashboard behavior through selectable values. A Boolean parameter can be used to switch a dashboard zone between visible and hidden states.

Steps to Create a Boolean Parameter

  1. Open the Tableau worksheet or dashboard workbook.
  2. Locate the Data pane.
  3. Right-click in the Data pane.
  4. Select Create Parameter.
  5. Enter a meaningful parameter name.
  6. Set the data type to Boolean.
  7. Choose TRUE or FALSE as the current value.
  8. Click OK to create the parameter.
  9. Display the parameter control when required.

Example Parameter Configuration

Property Configuration
Name Show Sales Details
Data Type Boolean
Current Value TRUE
Purpose Control the visibility of the sales details zone.
Best Practice: Use descriptive parameter names so that other developers can easily understand the purpose of each visibility control.

6. Creating a Calculated Field for Visibility

Calculated fields can determine whether a dashboard zone should be displayed. They evaluate conditions and return a Boolean result.

Example: Show Sales Details

Assume a Boolean parameter named Show Sales Details has already been created.

// Calculated Field Name:
// Sales Details Visibility

[Show Sales Details]

Example: Conditional Visibility

A calculated field can also evaluate a business condition. For example, a detailed sales view may appear only when the selected sales amount is greater than a specified threshold.

// Calculated Field Name:
// High Sales Visibility

SUM([Sales]) > 10000

This expression returns TRUE when the aggregated Sales value is greater than 10,000 and FALSE otherwise.

Important: The calculation must be valid for the worksheet and data context in which it is used. Aggregate and non-aggregate expressions must be handled consistently. Also, the calculation's result must be available for the visibility configuration.

7. Configuring Dynamic Zone Visibility

After creating the parameter or calculated field, the next step is to configure the dashboard container to use that field as its visibility control.

Configuration Steps

  1. Open the Tableau dashboard.
  2. Drag the required worksheets or objects into a supported layout container.
  3. Select the container in the dashboard layout.
  4. Open the Layout pane.
  5. Locate the Control visibility using value option.
  6. Enable the visibility control.
  7. Select the Boolean parameter or calculated field.
  8. Verify the visibility behavior by changing the controlling value.
Important: Dynamic Zone Visibility is configured through the Layout pane for supported dashboard zones. It is not simply a formatting option for every individual dashboard object. Place objects inside an appropriate layout container before configuring visibility.

8. Using Containers for Dynamic Visibility

Containers help organize dashboard objects and provide a practical way to manage visibility for groups of related content.

Horizontal Container

A horizontal container arranges its child objects from left to right. It is useful when a dashboard needs to display multiple related visualizations in a single row.

Vertical Container

A vertical container arranges its child objects from top to bottom. It is useful for grouping dashboard content into sections.

Benefits of Containers

  • Group related dashboard objects.
  • Manage visibility for a group of objects.
  • Maintain consistent positioning.
  • Organize complex dashboard layouts.
  • Make dashboard maintenance easier.
Vertical Container Horizontal Container Header Sales Chart Details Table Chart 1 Chart 2 Containers organize related dashboard elements into structured layouts.
Figure 2: Vertical and horizontal dashboard containers.

9. Showing and Hiding Dashboard Zones

Once Dynamic Zone Visibility is configured, users can control whether the associated dashboard content appears.

Visibility States

Condition Result Example
TRUE Zone is displayed. Show sales chart.
FALSE Zone is hidden. Hide sales chart.

Practical Example

A dashboard has two containers: one for Sales Analysis and another for Profit Analysis. Users can choose which content should be displayed by changing the controlling parameter.

Example Behavior:
  • Show Sales = TRUE: Sales Analysis is displayed.
  • Show Sales = FALSE: Sales Analysis is hidden.
  • Show Profit = TRUE: Profit Analysis is displayed.
  • Show Profit = FALSE: Profit Analysis is hidden.

10. Dynamic Visibility Using Multiple Parameters

A dashboard may contain several visibility controls. Separate parameters can control different dashboard containers, allowing users to customize the information displayed.

Example Parameters

Parameter Controls Data Type
Show Sales Sales Analysis container Boolean
Show Profit Profit Analysis container Boolean
Show Regional Map Regional Map container Boolean
Show Product Details Product Details container Boolean

Calculated Field Examples

// Sales Visibility
[Show Sales]

// Profit Visibility
[Show Profit]

// Regional Map Visibility
[Show Regional Map]

// Product Details Visibility
[Show Product Details]

Each calculated field can be assigned to the corresponding dashboard container through its Layout settings.

Design Consideration: Too many independent visibility controls can make a dashboard difficult to use. Provide clear labels and organize controls logically.

11. Dynamic Visibility with Dashboard Actions

Dashboard Actions and Dynamic Zone Visibility can be used together to create more interactive reporting experiences.

Dashboard Actions respond to interactions such as selections, highlighting, and navigation. Dynamic Zone Visibility controls whether supported dashboard zones are displayed based on their visibility condition.

Example Scenario

A user selects a product category in a dashboard. The selection can be used as part of an analytical workflow, while a parameter controls whether a product details container is displayed.

Possible Workflow

  1. Create a dashboard with a category chart.
  2. Create a product details container.
  3. Create a visibility parameter.
  4. Configure Dynamic Zone Visibility for the details container.
  5. Use dashboard actions to filter or highlight related information.
  6. Test the complete interaction.
Important: Dashboard Actions and Dynamic Zone Visibility are separate features. An action does not automatically control zone visibility unless the workflow is configured to update the field or parameter used by the visibility condition.

12. Practical Example: Sales Dashboard with Dynamic Visibility

Consider a company that wants to display sales information in a dashboard. The dashboard should allow users to show or hide Sales Analysis, Profit Analysis, and Regional Analysis sections.

Required Worksheets

  • Total Sales KPI
  • Monthly Sales Chart
  • Profit Trend Chart
  • Regional Sales Map
  • Product Details Table

Required Parameters

  • Show Sales Details
  • Show Profit Details
  • Show Regional Analysis

Dashboard Layout

DYNAMIC SALES DASHBOARD Visibility Controls Show Sales | Show Profit | Show Regional Analysis Sales Analysis Monthly Sales Chart Profit Analysis Profit Trend Chart Regional Analysis Regional Sales Map Product Details Product Performance Table
Figure 3: Example of a dashboard with multiple dynamically controlled sections.

Implementation Steps

  1. Connect Tableau to the sales dataset.
  2. Create the required sales and profit worksheets.
  3. Create a regional sales map.
  4. Create the product details worksheet.
  5. Create Boolean parameters for the required sections.
  6. Create calculated fields for visibility where required.
  7. Build the dashboard using layout containers.
  8. Place related worksheets inside their respective containers.
  9. Configure Dynamic Zone Visibility for each container.
  10. Display the parameter controls.
  11. Test each visibility condition.

13. Dynamic Visibility vs Traditional Filtering

Dynamic Zone Visibility and traditional filtering are different techniques. Both can change what users see, but they operate at different levels of the dashboard.

Feature Dynamic Zone Visibility Traditional Filtering
Purpose Controls the visibility of supported dashboard zones. Controls which data values are displayed.
Control Boolean field or parameter condition. Filter field and selected values.
Effect Shows or hides dashboard content. Restricts data within a visualization.
Example Show or hide the regional map. Display only the East region's sales.
Use Case Conditional dashboard layouts. Data exploration and analysis.

14. Common Dynamic Visibility Problems

Dynamic visibility may not work as expected if the parameter, calculated field, container, or visibility configuration is incorrect.

Problem Possible Cause Suggested Solution
Container is always visible Visibility condition always evaluates to TRUE. Review the parameter and calculated field.
Container is always hidden Visibility condition evaluates to FALSE. Check the current parameter value and calculation.
Visibility option is unavailable Unsupported zone or incorrect layout selection. Review the selected container and supported layout configuration.
Parameter control does not change visibility Wrong parameter or field is assigned. Verify the visibility control configuration.
Unexpected dashboard spacing Container arrangement or layout behavior. Review tiled and floating objects and container sizing.
Calculated field error Invalid expression or incompatible aggregation. Correct the calculation and verify its Boolean result.

15. Dynamic Visibility Best Practices

A well-designed dynamic dashboard should provide clear controls and predictable visibility behavior.

  • Use meaningful names for parameters and calculated fields.
  • Use Boolean values for visibility conditions.
  • Group related dashboard objects inside suitable containers.
  • Keep visibility controls easy to understand.
  • Avoid unnecessary dashboard sections.
  • Test both TRUE and FALSE conditions.
  • Review dashboard layout after hiding a container.
  • Use consistent spacing and formatting.
  • Document complex visibility logic.
  • Test the published dashboard experience.
Best Practice: Design the dashboard around the information users need most often. Use dynamic visibility for optional or secondary content rather than hiding essential business information.

16. Practical Exercise: Create a Dynamic Dashboard

Build a Tableau dashboard that allows users to show and hide different analytical sections using parameter-controlled Dynamic Zone Visibility.

Exercise Requirements

  1. Create a sample sales dataset connection.
  2. Create a Sales Analysis worksheet.
  3. Create a Profit Analysis worksheet.
  4. Create a Regional Map worksheet.
  5. Create a Product Details worksheet.
  6. Create Boolean parameters for the dashboard sections.
  7. Create the required Boolean calculated fields.
  8. Build the dashboard with appropriate containers.
  9. Configure visibility for each supported container.
  10. Display the parameter controls.
  11. Test all visibility combinations.
  12. Review the final dashboard layout.
Expected Result: A dashboard where users can independently control the visibility of sales, profit, regional, and product analysis sections using the configured visibility parameters.

17. Dynamic Visibility Quick Reference

Component Role
Boolean Parameter Provides a TRUE or FALSE control value.
Calculated Field Evaluates a condition and returns a Boolean result.
Layout Container Groups related dashboard objects.
Layout Pane Provides the visibility configuration.
Dynamic Zone Visibility Controls whether the configured zone is displayed.
Parameter Control Allows users to change the parameter value.

Summary

Dynamic Visibility in Tableau helps dashboard developers control the display of supported dashboard zones using Boolean parameters and calculated fields. In this lesson, we explored Dynamic Zone Visibility, Boolean conditions, parameter creation, calculated fields, layout containers, visibility configuration, multiple parameters, and the relationship between dashboard actions and visibility controls. We also compared Dynamic Zone Visibility with traditional filtering and discussed practical dashboard examples, troubleshooting techniques, and design best practices. By applying these techniques, developers can create organized, flexible, and interactive dashboards that display relevant information according to user requirements.