We use the Parameter to select the Sheet or Sheets dynamically on the Dashboard.
1) Create 3 Reports Individually.
a) Chart b) Line c) Text
2) Create a Parameter, here Values are defined as per our requirement.
3) Create a Calculated Field, which used to define the values which we can select from Parameter.
4) Drag "Sheet Selection" calculated field & define the values, if we select any one of these values then we will get this sheet on the Dashboard.
Here, values are All, Chart, Chart & Line, Chart & Text for "Chart" sheet
5) Similarly, we can define the values for sheets "Text", Line"
6) Now add all 3 reports to Dashboard.
Now we can select the Sheets according to requirement.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.