Step1:

Create parameter

Untitled.png

Step2:

Create calc

case [show Population] when "show population" then SUM([Population (count) (copy)])

when "hide population" then null

end

 

Step3:

Create one sheet1 and rag dim into row and Drag this calculation into text.

 

Step4:

Create calc new(use the same parameter here)

if [show Population] = "show population" then "Population"

Else "" end

 

Step5:

Create new sheet2 and add this new calc into text

 

Step6:

Drag the sheet1 into dashboard.

 

Step7:

Drag the sheet2 into title area like population.

 

Step8:

Show parameter control now.