How to create a “sheet selector” that gives the ability to select an individual sheet from the dashboard and replace all sheets with just the sheet selected.
Select create parameter by Right-clicking on data window to the left.
In parameter dialog box assign values as shown below:Data type: StringAllowable values: ListList of values: All, Sheet 1, Sheet 2,...and give it a name
Create a calculated field by Right-clicking on data window to the left)
Give parameter name from step 2 in the Formula text box.
For each sheet in the workbook, drag calculation field created in step 4 into filters shelf and do as follows:
In general tab, select custom value list
type All in the text box and click add item button. type particular sheet name and click add item.
create a dashboard
Right-click on the worksheet and select Parameter --> Select a sheet. You can find a new filter added to your right side and you can select which sheet to show in the dashboard.
If you want to learn more about tableau analytics then you can check our Tableau Training online.