Not only was this wicked helpful, but I was able to expand on this: I had my parameters switch between five maps. It worked great until I realized I had data points in Alaska and Hawaii as well! So I HI and AK maps for each continental map, restricted to those states but with the same filters/details/colors etc.. then I added two vertical containers (one for HI and one for AK) and repeated the steps in Andy's video above to add these "submaps". Then I made these floating and positioned where I wanted them. Works like a charm to add Alaska and Hawaii when I have data points on one of my maps! THANK YOU!!!
Thank you! I needed to make a small adjustment for version 2024.1.2 : when creating the chart type selected filter, select Wildcard, select Exactly matches, and enter the exact param value you want to trigger off. I eventually moved away from this technique to use dynamic zone visibility parameter control instead but this was super helpful nevertheless.
I knew about the use of parameters to swap the sheet, but this, leveraging the parameters action to dynamically update the parameter is magical, a big thanks Andy, any other use case, you'd like to give other than changing chart type ?
Great tutorial. However, when I select the individual parameter drop down "bar" on the Bar Chart tab, it changes bar to a bar drop down for all the other tabs (Line Charts & Map). How can I get this to stop from happening? The result is that only the line chart and map are showing when toggling between chart types on the final dashboard.
Hello Andy thank you for sharing this knowledge, quick question: it is working for me and hiding after removing the title but if I change the dashboard size to ¨automatic¨the spaces of the other charts appear again... do you know how could I make it work in automatic size?
Hi Andy, Thank you for this! I am trying to do this same thing with different charts altogether (not chart type, rather fully different data), BUT I need to be able to see the legend when the Viz changes on click. Is that possible?
You would need to have the legend for each worksheet in the dashboard. I’d recommend hiding the titles on those so that they appear to go away when you swap sheets.
Hi Andy, I am unable to use "Chart Type Selection" Calculated field to Filter out Bar/Line/Map. While being in Bar Chart sheet, I select Line or Map in "Chart Type" Parameter, it does not go blank. Kindly help me to filter out Bar/Line/Map using the calculated field. I am using Tableau Public (desktop version). Thanks in advance. Mythili.
Double check how you are adding it to the filters. Change the parameter so the chart appears on one sheet, then filter the other two sheets to exclude that option in filter. Repeat for the other sheets. So each sheet should have two items excluded in the filter.
Thank you@@vizwiz. As suggested, I duplicated the "Chart Type Selection" Calculated field and added this duplicate one to Filter shelf to exclude two items. Thus each sheet had two items excluded in the filter. I completed the dashboard as shown in the video.
@@mythilisubramanian6580 Thank you for the tip! Like you, I found that selecting, say, Line in the parameter did not cause the others to go blank. Even adding a duplicate to the filter and setting it to "exclude" did not help. I finally got it to work by, for example, creating a custom "Exclude Bar and Line" with the code [Chart Type] != "Bar" AND [Chart Type] != "Line" and put that on the Map filter set to TRUE. I then put a "Exclude Line and Map" on the Bar and "Exclude Bar and Map" on the Line.
Hi Andy, I am able to replicate everything except the parameter actions part. If I use one parameter action, it works fine but when three action parameters are there, the toggling of values in the parameter doesn't work. Can you please help, Already tried so many things !!
Hi Andy, I am using Tableau 2022.2.6 and have been trying to set up the parameter "switch" calculated field to function but without any success. Is there something different about this version that would not allow the chart to toggle between the chart types? Thanks Andy in advance. Caroline.
Yeah no problem. Sorry I've not been around to much. Just have a lot going on with my case life bills and on top of that catching another case. Four weeks since I received any income. It's like I take a step forward to get knocked down three steps back.
you have to hide the sheet titles, make sure they are all in a single container, and make sure none of them are fixed size. You can download the example.