You can accomplish this using a Parameter and sheet swapping.
More on sheet swapping go to Creating a Sheet Selector for a Dashboard | Tableau Software
1. Create a calculated field containing the Text for Europe.
2. Create a sheet for each Continent.
Next create a Parameter to use as a filter.
Now that you have a Parameter and the sheets in place, you can start the magic.
Create a calculated field that contains the Parameter only.
Next thing you want to do is drag this onto the filter pane of each Sheet and Select Customer Value List and type in the name of the continent.
Finally create a dashboard and use a Vertical Container. NOTE - You need to hide the title on all of your sheets for this to work. Make show to Show Parameter Control, since this will be the users "Filter".
Here is what it looks like when US is selected.
And here is Europe
Hope this helps!
Sheet Swap.twbx 31.8 KB
You are AWESOME! Thank you for that very detailed explanation. I'll check it out once I know what data I do not have from the regions!
I appreciate your quick and very detailed response!
No problem. Also, since you have to hide the title for the Swapping trick to work, I suggest created another sheet to use as a dynamic title.
Simply create a new sheet and drag the "Display" calculation in the Text Marks. And do some edits.
Then drag this onto the Dashboard above the Vertical Container.
When users change the parameter, the Title will update with it.