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.
Certification in Digital Marketing |
Certification in Big Data Analytics |
Certification in Cloud & Devops |
Certification in Full Stack Web Development
Big Data and Data Science Master’s Course |
Data Science Architect Master’s Program |
Cloud and DevOps Architect Master’s Course |
Artificial Intelligence Engineer Master’s Course |
Microsoft Azure Certification Master’s Training
Data Science Course Online |
Big Data Hadoop Certification Training |
Machine Learning Course Online |
Artificial Intelligence Course and Training |
Salesforce Certification Training: Administrator and App Builder |
Tableau Training and Certification Course |
Python Data Science Course & Training |
Ethical Hacking Course |
Business Analyst Course |
Courses in Cyber Security
© COPYRIGHT 2011-2021 INTELLIPAAT.COM. ALL RIGHTS RESERVED.
Download Salary Trends Now !
Learn how professionals like you got up to 100% Salary Hike.