---
schema_version: "1"
id: ab72f96f764d6ebc52f36567eb2c304d14b89250b87a7976b9aec9bd806be4bf
title: Create a Sheet Selection Menu for a Dashboard
collection: tableau
version: current
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/current/en-gb/public/desktop/dashboards_sheet_selector.md
canonical_url: https://help.tableau.com/current/public/desktop/en-gb/dashboards_sheet_selector.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 74881b6c9e768b34f711e6ed39f92edff676446828d6d2eacbc7e09ed5f919ec
description: Create a sheet selection menu using a parameter and calculated field to swap views in a dashboard.
---
[Skip to main content](#main-content)

# Create a Sheet Selection Menu for a Dashboard

Using a combination of a parameter and a calculated field, you can create a drop-down menu that lets users select an individual view that automatically expands to fill a dashboard.

**Tip:** To show sheets using separate buttons rather than a single menu, instead use [Show/Hide buttons](https://help.tableau.com/current/public/desktop/en-gb/dashboards_create.htm#Show). This is a much simpler approach, though each button will reveal a separate object. To leave a dashboard and open a completely different sheet, use [Navigation objects](https://help.tableau.com/current/public/desktop/en-gb/dashboards_create.htm#Add).

![Select a View dropdown displaying options for All, Map, Bar Chart and Line Chart.](/tableau/current/en-gb/public/desktop/en-gb/Img/CreatingSheetSelector_Main.png)

1. On an individual worksheet, right-click an empty area of the Data pane at left, and select **Create Parameter**.
    
    ![Create a parameter on a worksheet.](/tableau/current/en-gb/public/desktop/en-gb/Img/sheet_selector_parameter.png)
2. In the Create Parameter dialog box, do the following:
    
    - Enter a name that will appear appear above the menu, like **Select a View**.
    - For Data type, select **String**.
    - For Allowable values, select List.
    - Under List of values, type **All** for the first value, and then add values with the name of each view in the dashboard.
        
        ![The Edit Parameter dialog displaying the Name field.](/tableau/current/en-gb/public/desktop/en-gb/Img/CreatingSheetSelector_Parameter.png)
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.
    
    ![A dialog box to confirm the validity of a calculation.](/tableau/current/en-gb/public/desktop/en-gb/Img/CreatingSheetSelector_CalcParameter.png)
6. Open a 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:
    
    - Select **Custom Value List**.
    - Type **All** in the text box, and click the **Add Item** button.
    - Type the current view's name (like “Map”) in the text box, and click the **Add Item** button.
    
    When you're done, click OK.
    
    ![The Filter dialog displaying the Add Item icon to create a custom value list.](/tableau/current/en-gb/public/desktop/en-gb/Img/CreatingSheetSelector_FilterBarChart.png)
7. Repeat step 6 for every sheet you plan to add to your dashboard.
8. Select **Dashboard** \> **New Dashboard**.
9. From the Objects section at lower left, drag a **Vertical** or Horizontal layout container to the dashboard.
    
    ![Drag objects onto a dashboard.](/tableau/current/en-gb/public/desktop/en-gb/Img/sheet_selector_layout_container.png)
10. Now drag each sheet to the layout container, identified by the dark blue outline.
    
    ![Drag a worksheet onto the dashboard.](/tableau/current/en-gb/public/desktop/en-gb/Img/sheet_selector_layout_container_addto.png)
11. To display the sheet selector, from the drop-down menu at the top of a view, choose Parameters > \[new parameter name\].
    
    ![Apply a parameter to a dashboard.](/tableau/current/en-gb/public/desktop/en-gb/Img/sheet_selector_parameter_apply.png)
12. To ensure that selected views fill the dashboard, do the following:
    
    - From the drop-down menu at the top of each view, ensure that Fix Width is _not_ selected.
    - Right-click the title area of each view in the dashboard, and select Hide Title.

Your sheet selector is ready to go! For similar examples, see [Use Parameters to Make Views More Interactive](https://help.tableau.com/current/public/desktop/en-gb/changing-views-using-parameters.htm).