Is there a way to hide / unhide a visualisation

[MB_UK]

Hello,

I'm new to Looker Studio and am trying to build a dashboard where I can hide/unhide visualisations based on the button or something.

We have data coming in from Test and Prod which I've stored in a table. The table structure is exactly the same. I wanted to create two tables one from Prod and another from Test and use a button to allow users to toggle between PROD and TEST data. 

Is such functionality available? If not has anyone found a work around for this? Any suggestions or links will be very helpful.

Thanks in advance 🙂

[Spreadsheep]

Not that I know of. Only workaround I can think of is if your data is in bigquery, you can union all both prod and test datasets, then use a parameter to filter for one dataset. The query will process both datasets though initially which isn't ideal.

I think it would be better to have a seperate report for each dataset though personally.