How to Swap Sheets in Tableau

Step 1:

Build a diverging bar chart by using profit on the column shelf and state on the row shelf.

Step 2:

Duplicate that sheet. Move profit to the text mark to create a crosstab

Step 3:

Create a string parameter to allow your user to swap between a bar chart and a crosstab

Step 4:

Create a filter to test if the parameter chosen is “Bar”

[Chart Type] = “Bar”

Step 5:

Set the bar sheet to only true values, and exclude true values on the crosstab.

Step 6:

Add both sheets to a container on a dashboard. Make sure you hide all titles. Only one chart will show at a time.