Going Deep with Tableau Tooltips: Switching Vizzes

Data

Going Deep with Tableau Tooltips: Switching Vizzes

This series examines some advanced techniques of Tableau Tooltips and will help you effectively build upon an already solid foundation.

You are probably already aware of sheet swapping within a dashboard in Tableau, whereby a parameter is provided for the user to select the visualisation they want to see … Check out my colleague Keith Dykstra’s blog post that contains some great ideas on improving the user experience of sheet swapping.

We can also use a similar technique to allow users to choose which visualisation to show in a tooltip:

How to Swap Between Viz Views

To build this out, first we need to build the main view and the two views we want to toggle between in the tooltip. Once these have been built, we need a parameter to switch between them. Set up the parameter as below:

Now we need to create a string calculation to add the correct viz into the tooltip. Use a calculation like the one below (update the strings in the green boxes to the names of your sheets, and adjust the width and height of the viz in tooltip as required):

Applying Filters to Target Sheets

But this calculation alone isn’t enough. If we bring this into our tooltip, the switching mechanism will work, but we will not pass any filters through to the target sheets. To make sure our filters pass through, we need to add both views into the tooltip as well. When we add them in, adjust the height and width to one pixel so that they won’t display. We’ll only see the sheet targeted by the calculated field. The tooltip window will look like this:

Note: Because both sheets have been added as a 1×1 pixel, you will see a message saying “view is too large to show” at the bottom of the tooltip when using this technique.

Add the parameter control to your dashboard, and now your user will be able to select which view they want to see in the tooltip. Nice and easy! Be sure to stop back for the next post in this series on Tableau tooltips.

More About the Author

Angus Eady

Analytics Consultant
Going Deep with Tableau Tooltips: Background Formatting A common irritation with tooltip formatting in Tableau is that there is no way of changing the background colour of the tooltip. So, if ...
Going Deep with Tableau Tooltips: Adding Images Bringing an image into a tooltip can be a great way to show additional information in a visually interesting way without overcrowding a ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072