1 of 1 people found this helpful
For #1, you've stumbled upon a problem with using this sheet swapping technique with "gridless" worksheets. The trick is to create a "Blank" dimension (just create a calculated field with the value of "Blank") then add that to the rows and columns shelf. (See the following for a bit more detail on this problem: Vizible Difference: Sheet Swapping with Pie/Tree Map/Packed Bubble Charts). Once this is resolved, another thing I'd recommend is to click on each of the sheets within the container and change the outer padding to 0. Otherwise, each sheet will take up some space, even when the chart is not visible. See the attached workbook for a working version.
For # 2, you'd need to use a similar technique, but instead of a parameter, you'll need to create some additional data to use as a filter (the additional data would just have each of the your chart options). Here's a good step-by-step blog on how to do it: How To: Tableau Sheet Selector with Dashboard Actions | Sir Viz-a-Lot
If this helps to resolve your issue please be sure to mark this as the "correct answer." This will help others who may have similar questions in the future. Thanks!
I can't think of any other way to do this than with a join. A parameter cannot be controlled by an image, unfortunately.
Is there a reason you want to avoid the join?
For my work I cannot use excel as a source in Tableau.
Need to figure out a new approach for JOIN.
Definatelly, no way to use join as I have been waiting more than 60min on joing and it's still in progress
Just to join to 3 records? Are you using the superstore data set or some other data set?
I use some other data set, Big Data, more than 100.000.000 of records
2 of 2 people found this helpful
Good timing...was just playing with something similar for work!
So this is a little more complicated that my Sheet Swap with Action Filters...the simple version! as we need to "kill" the sheets we don't want to see, when we click an icon. So for each icon action ,we need 2, one to show that one and another to kill the others.
So first, as per my post we set up to dummy dimensions [1One] = 1 and [0Zero] = 0, and we bring each of these onto the Icons, level of detail
I'll show the actions for Profit, but just repeat the same logic for the other 2 (which I've done in the attachment)
So first we set up an action to show profit (this also 'overrides' and previous "kill" actions)...notice the set up, carefully (leave filter and selected dimensions)
and then we also need an action to "kill" the other 2! (again, notice the setup, carefully)
and we repeat this for the other 2, so we end up with 6 actions (so we don't even need the parameter anymore)
If you want an explanation of exactly how/why this works...I did a Think Data Thursday, ages ago, where I showed this Think Data Thursday: My Daily AdVIZture - August 25, 2016 (no need to bore yourself with the whole hour! if you forward to the 35 minute mark and watch from there, that is the Actions bit)
This technique works really well for Tablet and Phone's where you want this "button" click control (rather than trying to select a mark, or use drop-downs)
Nice solution Simon!
Thank you very much Simon!