KNOWLEDGE BASE

How to show/hide the middle of hierarchy fields in the dashboard


Published: 17 Feb 2023
Last Modified Date: 17 Feb 2023

Question

How to show/hide the middle of hierarchy fields in the dashboard
User-added image

Environment

  • Tableau Desktop 2022.4.0
  • Windows 10

Answer

Use the sheet selection menu to show/hide sheets.
1. Create a parameter:
Name: show/hide header
Type: string
Value: show, hide
2. Create a calculated field:
Name: filter
Value: [show/hide header]="show"
3. Drag [filter] to sheet1, and select [ture]
4. Drag [filter] to sheet2, and select [false]
5. Create a dashboard, drag a verticle object to the dashboard, and show sheet1 and sheet2.
6. Hide the titles of two sheets, and show the parameter.
 
Did this article resolve the issue?