By: Oliver Linley
Ollie lives in Cape Town, South Africa, and is passionate about all things data - and all things Tableau! If you have a question, feel free to reach out to him directly via email.
In the past, swapping worksheets in a Tableau dashboard has been possible but frustrating. Using a parameter, we could swap worksheets, but it was really difficult to also swap out any filters or parameters related to those worksheets.
Now, with Tableau’s Dynamic Zone Visibility, that’s all changed! Dynamic Zone Visibility allows us to switch between multiple connected elements on a dashboard, from single worksheets, to multiple worksheets; from a certain set of parameters to another; or from one worksheet with its legends, filters, and parameters, to another.
Dynamic Zone Visibility relies on Boolean fields to work. These simple fields allow Tableau to use TRUE/FALSE logic to determine what to display and when. By using a parameter tied to a Boolean field, we can give our end users the power to select which view to display.
What do you need to make Dynamic Zone visibility work? Here’s my checklist:
A parameter that allows you to select different between the various options to display in your dashboard.
Boolean calculated fields connected to the parameter.
A container in your dashboard containing the worksheets/elements that you want to swap.
In this week’s video, I’ll walk you through how to do a basic worksheet swap using Dynamic Zone Visibility!
You can access and download the Tableau Workbook from the video here.
Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss new blog posts, videos and events!