Attached is an example, from an old question I answered.
So the calculated field is simply the Parameter
You then add this to the filter of each sheet, and set the filter (using the Custom List) to the value of the parameter, when you want that sheet to be shown
here is the KB article with step-by-step instructions Creating a Sheet Selector for a Dashboard | Tableau Software
...let me know if you have any problems
Sheet Swap With Titles.twbx 371.5 KB
Thank you, but I want that in a sheet not a dashboard, do you have an idea of how to make this?
After creating this sheet, I will place it just as one sheet in my dashboard that contains other sheets..
Why do you want to do it, in a single sheet? once 2 sheets are in a container on a dashboard they are as if it's all in one sheet.
If you did want to do this though...and the chart type was the same, you could parameterise the measure (example attached)
or you could do it with a Dual Axis (again example attached)...although by the time you've done this you may as well have different sheets and use a traditional swap.
Measure Selector - SR.twbx 452.1 KB
I wanted to do it because it is a small space, but your sentence " once 2 sheets are in a container on a dashboard they are as if it's all in one sheet " enlightened my sight that I can put them over each other and consider a container like a sheet. Thank you very much!
1 of 1 people found this helpful
once 2 sheets are in a container on a dashboard they are as if it's all in one sheet
...it's a good point, that my statement isn't 100% true! There is a small amount of space (a couple of pixels) that the "collapsed" sheet takes up, in a traditional container (I have some models with 4 sheet swaps and the space the 3 "collapsed" sheets take up is noticeable (not so bad I can't live with it!!...we allow our dashboards to re-size so can't use floating objects). However, yes, if you can use floating objects, and float the sheets exactly over one another this problem goes away, and there is no wasted pixels!
Here's a blog on this
and a follow up on, with containers
Thank you Simon. I hope to find a solution for the other case, as I am not sure yet how we will make the size of the dashboard.