KNOWLEDGE BASE

How To Show And Hide Axis Header For Multiple Sheets On Dashboard


Published: 25 Mar 2021
Last Modified Date: 27 Oct 2022

Question

How to show and hide axis header for multiple sheets on dashboard

Environment

  • Tableau Desktop

Answer

Use a parameter to swap sheets one with the axis and one without the axis based on parameter value.

Step 1: Create a parameter like below:
User-added image
Step 2:

Create a calculation using this parameter and Filter with a custom value 2 on sheets where Show header on axis is disabled and custom value 1 on sheets where Show header on axis is enabled

User-added image

Step 3:

Drag the swappable sheets into a single vertical container on dashboard 

Repeat the steps above for all sheets that you want to show in the dashboard

Results for Show Header and Do not show header:

User-added image 
User-added image
Did this article resolve the issue?