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.