Search
  • Robert Breen

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.





3 views0 comments