You can pop sheets in and out of the dashboard.
We made a video to demonstrate how to do that. (The first half is swapping. That's where you different sheets in the same location based on some condition like a parameter value. The second half is popping. The video pops a legend in and out, but you can pop anything -- sheet, a whole container of stuff, whatever.)
See link here:
Thank you for the reply ,Joe.. But Will this work for two dashboards as I have mentioned in the question?
1 of 1 people found this helpful
Sure. You do a filter action where you pass the product name to the sheets on second dashboard. On the second dashboard your sheets will hide/display based on the value that was passed.
For that matter, if all the sheets on the second dashboard are generated from the same data source, you could probably just have one sheet (for each type of viz) that filters to the selected product instead of separate sheets for each product.
Hi Joe, I tried using your method. It's working perfectly fine for a single dashboard. But I cannot control the second dashboard (to which i need to navigate) from the first dashboard. It would be very helpful if you could show me an example file because it may be the lack of proper interpretation from my side also.
Post your workbook. I don't have time to anonymize my workbook or to hack up something new.