Tableau Explained: Use a Parameter to Swap Sheets

Learn how to use a parameter to swap between sheets. This is a great, and easy, method for showing different types of charts in a dashboard. This allows the user to toggle between different charts.

[BryanBowersDesign]

You can do more than 2 charts...on each sheet, add the select filter, but then, edit filter and change to custom value list. Add the names of all the other charts than the chart you are on and click exclude. Then on dashboard, use floating containers for the sheets and make them all the same size and overlap each other. When you add the parameter, and select a sheet it will show on the dashboard and hide the others. When you go back to your sheets, those sheets that are not currently selected may look empty but they still have the content. Anyway, this was my work-around for 3 sheets. Thanks!

[Ivy_]

Thank you! This is EXACTLY what I was looking for! I am a beginner in Tableau and I appreciate you sharing how to do this.

[TB-dyem]

Thank you! very short and precise, thank you for explaining the reason behind your actions.
just got for yourself a new subscriber today!

[neerajsehtya]

Thank you so much for coming to rescue time and over again. This is the second time you have guided me through your videos. It is so easy to understand the way you explain.

The least I could do is subscribe to your channel. Thank you very very much once again, Sir :)

[vdevinganca]

Thanks a lot for sharing man, it was very useful on my job! You just won one more subscriber. Greetings from Brazil :)

[arpitgarg]

This is awesome way to filters sheets on one dashboard, really thanks man. I have one question though, Is there a way to remove the text boxes and blanks on the dashboard as well when we filter?

[LubomilaTerziyska]

Hi ! Thanks for the video! I did exactly the same, but yet it didn't worked in the END.

[rubikb]

Awesome and simply done.Easy to understand.

[michaelblack]

This works great for two sheets - thank you! When I add a third, I only have the option to exclude the first sheet from the second and third, why is this? It results in both 2nd and 3rd sheets showing up when I select either of them from the drop down. How do I exclude sheets 1 and 2 from 3 and 1 and 3 from 2, etc?

[yacobzuriaw]

This doesn't work for me. When I do it with three sheets, they each only show the chart within 3 separate containers, and not 1 overlapping container like is showed here (even after I remove the title).

[eduardogtc]

Hi Andre. Thanks for the video. I have a quick question. It worked well in a dashboard with a line chart, but when I used a treemap chart, it always leaves a space (when the treemap chart is hidden). Am I missing something?

[ssong]

Hi Andre, Why when I put all sheets into the dashboards after applying the parameters, either one sheet shows up taking up half of the screen and leaving the other side blank, which wastes lots of space of my dashboard. What could I have missed when dragging the sheets over to dashboard..

[trendly]

It worked! Thank you! Only issue is when I put in another graoh for another one, instead of displaying them one on top of another, it puts it underneath... I try and drag the slider down futher but it then displays a small graph in the tiny space... I can't figure out how to toggle between showing them behind each other instead of underneath?

[abhaytevatia]

AMAZING, thanks for this easy and superb trick

[iBennyfreshlemon]

thanks for sharing!!! it already helped me a lot! Is it possible to swap between tiles? beacuse with that swap function I am not able to to that! Thank you in advance

[goranmanojlovic]

hello, very useful. how do i apply this to 3 sheets? thanks

[DanielWeikert]

can you do more on prep with python? Especially the different output schemas seem to be interesting

[HK-jvwc]

Hey Andre, tried to do this with geodata on maps, and seems like the sheets are fighting for space in the dashboard for some reason any solution for that?

[tanguylienart]

Thanks a lot! How would this work for more than one Sheet? I need to find a smimilar option to show one of 6 sheets! Looks like this only works for two?

[Gerny]

Sometimes this works great but other times the two charts seem to be fighting for space and they split up half of the container. Nothing I can do seems to let me have them swap for a full view of the container.