You need to put your sheets into a container and use a "sheet swapping" technique. Take a look at the following blog which details how to do it, step-by-step: https://www.thedataschool.co.uk/hashu-shenkar/tableau-tip-switch-between-views-dynamically-on-a-dashboard/
Be sure to follow all of the steps closely as the containers can be a bit temperamental.
Need to add container when you create sheet swap dashboard.
I have changed your dashboard and attached.
BI, Aspire Systems (India) Pvt Ltd
hiding sheets.twbx 378.3 KB