This post is going to build on the foundations from part 1 and part 2 of the series. If you have not read part 1 and 2, I recommend you do so, by clicking here .

Let’s get into it.

First you will need to have a dashboard with 4 charts, any 4 charts will suffice (I’ve gone with superstore data), and I am going to layout the sheets into quadrants (Top Left, Top Right, Bottom Left and Bottom Right). Then, I am going to put each sheet into its own container. In addition, the Top 2 and Bottom 2 sheets/containers need to go into their own containers.

The Logic

The Logic behind the 4 sheet swapping is to use String parameters to control each container. I will start by creating a String Parameter, and I will call it ‘Region Swapping’. Then, I will label the parameter values by the Regions; Central, East, South and West. I am also going to include an ‘All’ option to show all charts.

The Calculated Fields

Next I will write the Calculated Fields, one for each of my 4 charts.

The reason I have included the ‘All’ for each of the expressions is because I want all Charts to show when the ‘All’ parameter is selected.

The Designation

Once I have finished with the Calc fields, I will assign these Calc fields to a chart (a container in my case) on the dashboard each. Then, I will assign the Calc Fields to their respective containers, and I will do this in these steps:

  1. First, show the Parameter and set it to ‘All’. This ensures that the containers don’t disappear as I set the Dynamic Zoning Visibility.
  2. Next, assign the 4 containers with their matching Calc Fields.

The Final Product

Finally, I need to test the dashboard to make sure it is behaving as I want.

CONGRATULATIONS, You now have a fully functional 4 quadrant sheet swapping/zooming 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.

The Data School
Author: The Data School