MIP Logo

Dynamic Zone Visibility – Part 1 – 2 Sheets

This post was originally published on The Data School blog between 2018 and July 2025, before our program was renamed to MIP’s Analytics Career Accelerator. References throughout this article to “The Data School” or “DS” all refer to what is now MIP’s Analytics Career Accelerator. The program, its people, and its commitment to launching outstanding analytics careers remain the same – just under a new name.

If you are having trouble viewing this article, please report it here

Are you excited about the new Dynamic Zone Visibility feature in Tableau 2022.3? You should be, because this new feature is going to blow you away!

Let’s get into it.

First you will need to have a dashboard with 2 charts. Any 2 charts will suffice (I’ve gone with superstore data).

The Logic

The Logic behind the chart swapping is to use Boolean parameters to control which chart shows, and which one hides. As such, we are going to start by creating a Boolean Parameter, and we will call it ‘Chart Swapping’.

The Calculated Fields

Next comes the Calculated Fields, one for parameter is ‘TRUE’ and the other for Parameter is ‘FALSE’, one each for our 2 charts.

The Designation

Once we are done with the Calc fields, we need to assign these Calc fields to a chart (OR container, if you have the charts in separate containers) on the dashboard each.

You will notice that upon completion of this step that one of your charts will disappear. Don’t worry, this is supposed to happen. The reason for this is that we have assigned one of our charts (or containers) to the parameter TRUE value, and the other to the parameter FALSE value.

The Final Product

Once we have completed all the above steps, we need to test our work to make sure it is behaving as we want. First, we need to show the chart swapping parameter on our dashboard. Then we need to test how our chart swapping behaves between the TRUE and FALSE values.

CONGRATULATIONS!! You now have a fully functional chart/container swapping dashboard without the annoying white space place holder that we had previous to Tableau 2022.3 with our hacks.

I hope you have found the post useful, and I will see you next time.

Share this post