Need help setting up your worksheet swap? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909 Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
Hi Eric. Thanks for calling out the Tableau issue affecting sheet swapping in v2022.2. In great tableau tradition of being able to achieve the same outcome several ways, there is a slightly shorter method which does not require the condition for activating sheet swapping. At 4:12 in your video, instead of going to 'Condition', go to General > 'Custom Value List > 'Enter Text to Search or Add'. on each sheet, enter the valid parameter entry; Map for sheet 1, Bars for sheet 2 and , Dot Plot for sheet 3. Select [+] on each sheet to add the relevant string.
thank you so much. So many RUclips videos out there on this subject and I didn't realize the older vids were out of date. Tearing my hair out following the steps of those videos exactly but then my screen wasn't doing what theirs was. So frustrating, and so relieved to watch your video about adding the formula. Woohoo!
I'd used this method before to enable flipping back and forth of worksheets on my dashboards but had no clue this update changed the way to do that. This is so helpful, thanks so much!
You are the best!! I've searched the whole internet trying to understand why my Tableau didn't hide the other options. Thanks a lot man!! You have made 1 person very happy today : X
Thsnk you so much for that video!! Amazing videos, easy to understand, easy to remember! You are not just experts in tableau, you also are amazing teachers! Well done, and thank you for that channel.
Nice, thanks! I noticed for these options Map, Bars, and Dot Plot you chose "Worksheet Selection Filter" for Maps and "Worksheet Selection Parameter" for Bars, and "Worksheet Selection Filter" for Dot Plot. Why not the same for all three? Thanks
Thank you for this video. I was thinking I was an idiot. I had looked at my own tutorial videos which used the old way. I was wondering if this way would work, but figured thought I would Google first. Thanks again. Do you mind if I make an update video for my own channel and give you the credit and a link?
@@onenumbertableau Weirdest thing. I went home and tried it with the latest version of Tableau Public and filter worked as expected the "old" way. Weird that there is a difference between Tableau Public and Tableau Desktop.
@@TheGrabBag_RootBeer How strange! I never tried this on Tableau Public. It definitely felt like it was unintended when Tableau changed this on Tableau Desktop (I could be wrong, maybe they wanted to change the way filters work by default). Maybe whatever programmatic change that happened in Tableau Desktop didn't get applied in Public?
@@TheGrabBag_RootBeer Sorry for the confusion. TheGrabBag is one of my other RUclips accounts. I accidentally posted my Tableau Public comment from there. I ended up not creating a video.
Great video! on the last step my two sheets in the container don't resize...it just has one half or the other go blank--is there a way to tell it to auto-resize?
Hi and great timing! Check out this video we just put out and ensure none of your objects are fixed height: ruclips.net/video/hPPgXTCzCM8/видео.html&ab_channel=OneNumber-TableauExperts
Spent longer today than I'd care to admit, trying to figure out what on Earth I was doing wrong--the traditional parameter/swap methodology all of a sudden wasn't working anymore. Totally v2022.2. Ugh. Thanks so much for the walk-through, Eric!
Hi, thanks for the heads up. I'm glad this helped! Can you try sizing the pie chart to entire view to see if that helps? How to here: ruclips.net/video/Ic6No-dFORU/видео.html
Sure! In modern version it's typically much better to swap worksheets with Dynamic Zone Visibility: onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
Thanks so much Eric! After spending several hours trying to figure out why I could no longer swap sheets (using the same method I've used for a few years now) your video solved the issue. Kind of irritating Tableau made the change (although I'm assuming they had a good reason ... or maybe not the way things at Tableau seem to be headed) without somehow making it more obvious to users how the change would impact their dashboards. Can't thank you enough for this one!
Not with this approach but it might be worth trying a worksheet swap with Dynamic Zone Visibility instead. How to here: ruclips.net/video/EkKgPs9ky4k/видео.html&ab_channel=OneNumber-TableauExperts
Great video! Working great for most of my objects except one. I have a table with 4 columns (KPI indicators) and it will display which ever table is listed higher in the item hierarchy layout but will just show a blank space when the one listed lower in the hierarchy is selected. This issue does not happen with my 3 other charts (2 line charts and 1 data table). Any ideas?
I'm guessing one of the objects in your container has a "fixed height". Click in the background of the sheet, and you'll see a little white pin the top right corner of that sheet. Deselect that white pin so it has a hollow middle. It is now a "dynamic height" object. Hopefully that does it!
@@onenumbertableau I am trying to do the same. Everyone shows how to make it work for 3 graphs . But it doesn't with 4 or more graphs. Tableau automatically ''fixed height'' for 4th container
@@denyskyrianov1701 Weird. I had never had that issue before but just tried to create a swap with 4 sheets and experienced the same issue you mentioned. I'm guessing this also has something to do with updates Tableau has made but I'm not sure what specifically. I think worksheet swaps with Dynamic Zone Visibility might be the best bet for 4+ worksheets: onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
Hi Eric, in 4:14 you've entered [Worksheet Selection Filter] for Map but in 5:03 you've entered [Worksheet Selection Parameter] for Bars. Then for Dot Plot, you've entered [Worksheet Selection Filter] again. May I know why is Bar's condition different from the rest? It seems that the swapping still work for all of them despite the different conditions.
Hi! Thanks for checking our video out. No real reason other than I accidentally referenced the parameter. I meant to reference the calculation all 3 times.
Thank you. The video is really helpful. I tried to implement same thing in my dashboard. But I am facing a different issue. I also have legend in my sheets. And when swapping sheets either both legends are present in both sheets or single one for both sheets which is not what I want. Can you help me with it?
Hey Keval, 2 options for you: 1. Get the legend to swap as well by tying it to a 3rd sheet: onenumber.biz/blog-1/2020/1/22/creating-dynamic-color-legends-for-worksheet-swaps 2. Use Dynamic Zone Visibility to swap and it an swap legends, filters, parameters too : onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
@@onenumbertableau Thank you for the help. I tried implementing the Dynamic Zone Visibility Method but I cannot find it in my dashboard. Could you please let me know what should be the minimum Tableau version for getting that feature? Also, can it be directly applied to a sheet or it must be applied to containers? Hoping for your reply soon.
You're welcome! You can, here's a blog post on it: onenumber.biz/blog-1/2020/1/22/creating-dynamic-color-legends-for-worksheet-swaps You might find it easier to use Dynamic Zone Visibility to swap numerous objects though: onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
When i choose to show color legend for each worksheet, there is always a blank row when i swap among worksheets. Is there a way to hide the color legend from other worksheets when showing one worksheet?
Your best bet is to tie the color legend/filters to a worksheet that isn't swapping. Check out this post on the topic: onenumber.biz/blog-1/2020/1/22/creating-dynamic-color-legends-for-worksheet-swaps
I suppose if you gloated a layout container and the objects were tiled inside the floating container, yes. However, Dynamic Zone Visibility is probably a better fit for swapping floating objects: onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
This is such a good question. I made a note to myself to make a follow-up video on this topic. No, unfortunately other objects like Filters, Legends and Parameters can't be easily swapped this same way. I recommend creating a third worksheet which doesn't change which things like Color Legends and Filters are connected to because a filter or color legend attached to a disappearing/collapsed sheet will display only null values. Here's a blog post about how to make dynamic color legends. This process should work for filters too onenumber.biz/blog-1/2020/1/22/creating-dynamic-color-legends-for-worksheet-swaps
Make sure that the little "Fix Height" pins on the worksheets in the layout containers are not selected. If the objects have been manually adjusted at all they are likely Fixed Height and then won't expand and Contract accordingly. If you're not sure what I'm talking about jump to around 5:20 in this video: ruclips.net/video/lG6HgkaKwTU/видео.html&ab_channel=OneNumber-TableauExperts
Are your filters applied to both sheets? (More info on how to do that here: ruclips.net/video/mq32Ln-2cNg/видео.html&ab_channel=OneNumber-TableauExperts)
Need help setting up your worksheet swap? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909
Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
You have no idea how useful this video has been for me!!! I spent more than 3 days trying to get this done. Thank you
That's so good to hear, we're happy to hear this helped!
you're a lifesaver
thank you
We're glad to hear it was helpful. You're welcome!
Thank you very much, your tutorial to the point and complete explanation
You are very welcome!!
Hi Eric. Thanks for calling out the Tableau issue affecting sheet swapping in v2022.2. In great tableau tradition of being able to achieve the same outcome several ways, there is a slightly shorter method which does not require the condition for activating sheet swapping. At 4:12 in your video, instead of going to 'Condition', go to General > 'Custom Value List > 'Enter Text to Search or Add'. on each sheet, enter the valid parameter entry; Map for sheet 1, Bars for sheet 2 and , Dot Plot for sheet 3. Select [+] on each sheet to add the relevant string.
Thank you Paul! That's great and that works too!
Finally, something that worked for updated version of Tableau!
We're so glad it helped!
thank you so much. So many RUclips videos out there on this subject and I didn't realize the older vids were out of date. Tearing my hair out following the steps of those videos exactly but then my screen wasn't doing what theirs was. So frustrating, and so relieved to watch your video about adding the formula. Woohoo!
You are welcome, so glad to hear it helped!
Great clear video!
Thanks, we're so glad it helped!
I'd used this method before to enable flipping back and forth of worksheets on my dashboards but had no clue this update changed the way to do that. This is so helpful, thanks so much!
You are welcome! We're glad to hear this helped!
Thanks for this update! I had been battling with the 'old' method not realizing Tableau changed it. Very frustrating!
You're welcome, we're glad to hear this helped!
You are the best!! I've searched the whole internet trying to understand why my Tableau didn't hide the other options. Thanks a lot man!! You have made 1 person very happy today : X
Thank you so much! We're so glad to hear this helped!
Amazing. Thanks for pointing out the method for updated version.
You are very welcome!
Great video !
I watched other ones and this one was super clear
Glad to hear it, thank you!
Thank you so much for your quick and easy-to-follow videos!
You are welcome! So great to hear you found it helpful!
Thank you so much! I was struggling to find a solution for this and this has been super helpful and a time saver! Thank you!
You are very welcome! So glad to hear this helped!
Thsnk you so much for that video!! Amazing videos, easy to understand, easy to remember! You are not just experts in tableau, you also are amazing teachers! Well done, and thank you for that channel.
Thank you so much, we really appreciate that and are glad to hear you are finding it useful!
Nice, thanks! I noticed for these options Map, Bars, and Dot Plot you chose "Worksheet Selection Filter" for Maps and "Worksheet Selection Parameter" for Bars, and "Worksheet Selection Filter" for Dot Plot. Why not the same for all three? Thanks
Good eye! It was a mistake. While it works, I'd probably try to consistently choose the calculation each time.
Thank you for this, been banging my head all morning why this wasn't working! Great video and explanation !
You are welcome! We're glad it helped!
Very good demonstration
Thank you! We're glad to hear it helped.
That change of additing the condition was the missing link - thanks for showing that was going crazy
We're so glad to hear this helped and preserved your sanity!
Thank you for this video. I was thinking I was an idiot. I had looked at my own tutorial videos which used the old way. I was wondering if this way would work, but figured thought I would Google first. Thanks again. Do you mind if I make an update video for my own channel and give you the credit and a link?
Hey Weston, so glad to hear this helped. And of course, by all means! Thanks for checking!
@@onenumbertableau Weirdest thing. I went home and tried it with the latest version of Tableau Public and filter worked as expected the "old" way. Weird that there is a difference between Tableau Public and Tableau Desktop.
@@TheGrabBag_RootBeer How strange! I never tried this on Tableau Public. It definitely felt like it was unintended when Tableau changed this on Tableau Desktop (I could be wrong, maybe they wanted to change the way filters work by default). Maybe whatever programmatic change that happened in Tableau Desktop didn't get applied in Public?
@@TheGrabBag_RootBeer Sorry for the confusion. TheGrabBag is one of my other RUclips accounts. I accidentally posted my Tableau Public comment from there. I ended up not creating a video.
Great video! on the last step my two sheets in the container don't resize...it just has one half or the other go blank--is there a way to tell it to auto-resize?
Hi and great timing! Check out this video we just put out and ensure none of your objects are fixed height: ruclips.net/video/hPPgXTCzCM8/видео.html&ab_channel=OneNumber-TableauExperts
Just what I was looking for! thank you so much
You are welcome!
Thank you, well done, btw!
You are welcome, thanks!
Thank you very much fixed my dashboard!
You are welcome!
Spent longer today than I'd care to admit, trying to figure out what on Earth I was doing wrong--the traditional parameter/swap methodology all of a sudden wasn't working anymore. Totally v2022.2. Ugh. Thanks so much for the walk-through, Eric!
I hear you! I was teaching a class in August and it kept not working. I was wondering if I was going crazy! I'm glad this helped.
Very helpful, thank you.
You are most welcome!
This tutorial is very helpful, however when I try to apply the last step on pie charts, they did not resize very well
Hi, thanks for the heads up. I'm glad this helped! Can you try sizing the pie chart to entire view to see if that helps? How to here: ruclips.net/video/Ic6No-dFORU/видео.html
How would you do this in the 2024 version? Seems to be a lot more buggy with resizing the containers
Sure! In modern version it's typically much better to swap worksheets with Dynamic Zone Visibility: onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
Thanks so much Eric! After spending several hours trying to figure out why I could no longer swap sheets (using the same method I've used for a few years now) your video solved the issue. Kind of irritating Tableau made the change (although I'm assuming they had a good reason ... or maybe not the way things at Tableau seem to be headed) without somehow making it more obvious to users how the change would impact their dashboards. Can't thank you enough for this one!
We're sorry you had that experience and also glad to hear we were able to help!!
Great trick... just what I was looking form thank you
We're glad to hear this is helpful, you're welcome!
Thank you a million mate!!
Thanks Mate
You're welcome!
it's really helpful, thanks for sharing
I'm so glad this is helping you. Thanks for letting us know!
Great video.
Thanks for sharing.
You're welcome!
Whenever a sheet is swapped it leaves an empty box a few pixels high throwing off alignment. Anyway to get rid of those?
Not with this approach but it might be worth trying a worksheet swap with Dynamic Zone Visibility instead. How to here: ruclips.net/video/EkKgPs9ky4k/видео.html&ab_channel=OneNumber-TableauExperts
Great video! Working great for most of my objects except one. I have a table with 4 columns (KPI indicators) and it will display which ever table is listed higher in the item hierarchy layout but will just show a blank space when the one listed lower in the hierarchy is selected. This issue does not happen with my 3 other charts (2 line charts and 1 data table). Any ideas?
I'm guessing one of the objects in your container has a "fixed height". Click in the background of the sheet, and you'll see a little white pin the top right corner of that sheet. Deselect that white pin so it has a hollow middle. It is now a "dynamic height" object. Hopefully that does it!
@@onenumbertableau I am trying to do the same. Everyone shows how to make it work for 3 graphs . But it doesn't with 4 or more graphs. Tableau automatically ''fixed height'' for 4th container
@@denyskyrianov1701 Weird. I had never had that issue before but just tried to create a swap with 4 sheets and experienced the same issue you mentioned. I'm guessing this also has something to do with updates Tableau has made but I'm not sure what specifically. I think worksheet swaps with Dynamic Zone Visibility might be the best bet for 4+ worksheets: onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
Its working thank
But please add button filter to swap
Action not working
Please!
Thanks! Are you thinking of something like this? ruclips.net/video/xhr0EIUgf0I/видео.html&ab_channel=Tableau
Hi Eric, in 4:14 you've entered [Worksheet Selection Filter] for Map but in 5:03 you've entered [Worksheet Selection Parameter] for Bars. Then for Dot Plot, you've entered [Worksheet Selection Filter] again. May I know why is Bar's condition different from the rest? It seems that the swapping still work for all of them despite the different conditions.
Hi! Thanks for checking our video out. No real reason other than I accidentally referenced the parameter. I meant to reference the calculation all 3 times.
Thank you.
The video is really helpful.
I tried to implement same thing in my dashboard. But I am facing a different issue. I also have legend in my sheets. And when swapping sheets either both legends are present in both sheets or single one for both sheets which is not what I want. Can you help me with it?
Hey Keval, 2 options for you:
1. Get the legend to swap as well by tying it to a 3rd sheet: onenumber.biz/blog-1/2020/1/22/creating-dynamic-color-legends-for-worksheet-swaps
2. Use Dynamic Zone Visibility to swap and it an swap legends, filters, parameters too : onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
@@onenumbertableau Thank you for the help.
I tried implementing the Dynamic Zone Visibility Method but I cannot find it in my dashboard. Could you please let me know what should be the minimum Tableau version for getting that feature? Also, can it be directly applied to a sheet or it must be applied to containers?
Hoping for your reply soon.
@@kevalshah382 Hi Keval, Looks like it first released in 2022.3. It can be applied directly to any object (worksheet, filter, legend, parameter).
Thank you so much for sharing this trick. I do have a follow-up question: can you add different legends to those charts?
You're welcome! You can, here's a blog post on it: onenumber.biz/blog-1/2020/1/22/creating-dynamic-color-legends-for-worksheet-swaps
You might find it easier to use Dynamic Zone Visibility to swap numerous objects though: onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
Good to know about change on filter behavior on 2022 versions, still on 2020.4.3 😄😅
You never expect something like this to change but it can obviously happen! Glad to help.
When i choose to show color legend for each worksheet, there is always a blank row when i swap among worksheets. Is there a way to hide the color legend from other worksheets when showing one worksheet?
Your best bet is to tie the color legend/filters to a worksheet that isn't swapping. Check out this post on the topic: onenumber.biz/blog-1/2020/1/22/creating-dynamic-color-legends-for-worksheet-swaps
Does this work with floating objects??????
I suppose if you gloated a layout container and the objects were tiled inside the floating container, yes. However, Dynamic Zone Visibility is probably a better fit for swapping floating objects: onenumber.biz/blog-1/2022/3/29/tableau-dynamic-zone-visibility
If in case, my sheet has filters for each, can I also swap the filter the same way I swap the sheet?
This is such a good question. I made a note to myself to make a follow-up video on this topic. No, unfortunately other objects like Filters, Legends and Parameters can't be easily swapped this same way. I recommend creating a third worksheet which doesn't change which things like Color Legends and Filters are connected to because a filter or color legend attached to a disappearing/collapsed sheet will display only null values. Here's a blog post about how to make dynamic color legends. This process should work for filters too onenumber.biz/blog-1/2020/1/22/creating-dynamic-color-legends-for-worksheet-swaps
My layout container does not work. It still splits half screen each chart even after hidding title
Make sure that the little "Fix Height" pins on the worksheets in the layout containers are not selected. If the objects have been manually adjusted at all they are likely Fixed Height and then won't expand and Contract accordingly. If you're not sure what I'm talking about jump to around 5:20 in this video: ruclips.net/video/lG6HgkaKwTU/видео.html&ab_channel=OneNumber-TableauExperts
I followed this but when I apply a filter the second sheet gets hidden . Please help
Are your filters applied to both sheets? (More info on how to do that here: ruclips.net/video/mq32Ln-2cNg/видео.html&ab_channel=OneNumber-TableauExperts)