The cause of the problem is due to no pills on Rows/Columns shelves. These are the gridless chart types. The solution was to add some "Blank" dimensions to Rows/Columns and thus the problem got fixed. Remember to right click the Blank dimension and un-check "Show Header".
Click this picture to go to the interactive version.
As sheet swapping gets popular, similar problems came up often:
The above technique applies to all the chart types with no rows/columns pills: Packed Bubble, Pie and Treemap etc.
Note that in this thread, Zen Master Jonathan Drummey mentioned that he has long found the issue and its solution. He even posted an idea in as early as 2011, which still remains active:
Hope this idea gets implemented one day. Before that day, we have to live with the above tricks.
I've tried applying this method with a table, adding a blank pill to the row shelf since my column shelf already has a pill. I hide the labels and all, but the sheets still don't disappear. Any suggestions? Any solutions out there?
ReplyDeleteThe above applies to the 3 charts without columns and rows. You may need to try this http://vizdiff.blogspot.com/2016/03/seamless-sheet-swapping.html
DeleteSuperb solution !!!!
ReplyDeleteThank you SOOOO Much!
ReplyDeleteepic! thks 2019 and still working and tableau didn't add a feature for it.
ReplyDeleteHow you do it?!!! heeeelp! i have been doing the excercise for a long time and i can´t, the sheets still apear one in the top of the other, I have tableau 2019.2
Deletei dont know how to thankyou man
ReplyDeleteLife saving tip - thank you!
ReplyDelete2021 still thank you saved me
ReplyDelete