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.
