I'm hacking up an example of an idea you can use for this.
1 of 1 people found this helpful
There is a video we made (linked here: We made a video of Sheet Swapping and Legend/Filter Popping on a dashboard. ) that demonstrates sheet swapping AND object popping.
It's the second half, popping, that I used in this example. (Attached. Version 8.2 packaged workbook, but this works in any version.)
What I have in there:
A "main" container that looks like the main dashboard. It has two bogus sheets on it.
There are two containers floating behind it.
There is a parameter. If you choose value=1, a sheet in one of the containers displays. You don't see it, but in displaying, it pushes out a "popped" object. In this case it's another container that displays two other sheets.
If you choose value =2, the first pop sheet closes and a second pop sheet in yet another container displays. Again, you don't see it because it's all happening behind the "main" container. It displays the object it is controlling -- again, yet another container -- and that displays two other sheets.
You are limited in what you can pop out like this only by your creativity!
Keep in mind that you are not limited by the boundaries of your dashboard. You can place containers starting at negative x- and y-coordinates, and whole dashboard-sized containers can be hiding out of bounds, waiting to be pushed out by a pop sheet!
Hi James Keuning,
It may not exact solution for your situation,
What about using the Story option, In Story we can select the Dashbords dynamically.