Dynamically selecting the Sheets in the Dashboard

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.

7)

Now we can select the Sheets according to requirement.