Select Page

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

Let’s get into it.

First you will need to have a dashboard with 3 charts. Any 3 charts will suffice (I’ve gone with superstore data). Now, if you have read the post from part 1, you may wonder, how can a Boolean update 3 separate and different charts when there is only TRUE and FALSE? The answer, you can’t! But I am going to show you how we can swap between 3 different charts in a dashboard. Make sure that each sheet/chart is in its own separate container.

### The Logic

The Logic behind the sheet swapping is to use String parameters to control which chart shows. As such, I am going to start by creating a String Parameter, and I will call it ‘Sheet Swapping’. I will label the values by the chart type; Map, Donut and Bars. 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 the 3 charts.

I include the ‘All’ for each of the expression because we 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. I will assign the Calc Fields to the respective chart(s) they are inside them.

You will notice that upon completion of this step that 3 of your charts will disappear. Don’t worry, this is supposed to happen. The reason for this is that we have assigned our charts to the parameter values and there is only 1 parameter 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 parameter on our dashboard. Then we need to test how our chart swapping behaves between the Map, Donut, Bars and Line values.

CONGRATULATIONS!! You now have a fully functional 3 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.