Was this page helpful?
Yes No
Have a comment? Please leave it here. Thanks for your feedback!
All Tableau Help > Tableau Desktop and Web Authoring Help > 
Applies to: Tableau Desktop

Create a Sheet Selector for a Dashboard

Create a drop-down menu that lets users select an individual view and expand it to fill a dashboard.

  1. On an individual worksheet, right-click an empty area of the Data pane at left, and select Create Parameter.

  2. In the Create Parameter dialog box, do the following:

  3. Click OK

  4. On any sheet, right-click an empty area of the Data pane at left, and select Create Calculated Field.

  5. Give the calculation a descriptive name like Display sheet. In the formula text box, enter the name of the parameter you created above. Then click OK.

  6. One by one, open each sheet you plan to add to your dashboard, and drag the new calculation to the Filters shelf. Then do the following in the Filter dialog box, and click OK.

  7. Select Dashboard > New Dashboard.

  8. From the Objects section at lower left, drag a Vertical or Horizontal layout container to the dashboard.

  9. Now drag each sheet to the layout container, identified by the dark blue outline.

  10. Right-click the title area of each view in the dashboard, and select Hide Title.

    (If titles are visible, they prevent selected views from filling the dashboard.)

  11. From the drop-down menu at the top of a view, choose Parameters > [new parameter name].

Your sheet selector is ready to go! For similar examples, see Use Parameters to Make Views More Interactive.