I have attempted to do this with the help of "Actions" feature in dashboard. Please let me know if this helps.
There are few newly created sheets which are hidden.
Hi Marc MOUSSA,
Thank you for your help!
I really like your solution but I couldn't replicate it myself. (I've never used parameter before)
I have gotten as far as creating the parameters and put it on the dashboard as filter but I couldn't set it as filter on every single work sheet.
Please help to identify what I'm missing here.
Thank you so much!
Data sample tableau help.twbx 154.9 KB
There are still one step to do and that is to put in every sheet the following filter
[Parameter 1]=1 filtered to TRUE
Start by the first sheet, put this on colum or row then drag it to filter shelf and select the value true.
Then change the value of the parameter to 2, go to the second sheet and use [Parameter 1]=2 and do the same steps as above and so one till the last sheet.
In my attached workbook I have created parameter Select Dashboard base on selection tableau dashboard will show respected worksheet.
In my case I have worksheet called as R1 and R2.
Create Paramter : Select Dashboard
Create Calculated Field : C1
Field 2 - C2
Field 3 : C3
Now drag C3 in Filter pan and select value as TRUE
Now for Another Sheet R2
Field 4 : R2
Filed 5 : R3
Drag this R3 in filter pan and select value as True
Step 3 :
Create new dashboard and drag R1 and R2 worksheet.
Right click and make this sheet as floating. ( Floating will allow to place sheet on eachother same area will use for both worksheet)
Fix same height and width and location of both worksheet.
Final Dashboard look as below :
I have attached workbook for refrence, Hope it help :-)
D1.twbx 364.3 KB
On above sheet I have also dynamic hide and show worksheet on dashboard base on Parameter selection.
You can find details in D2 dashboard.
You have a lot of great suggestions to choose from here.
I've attach another link to an example that I had created a few years ago. It has always worked well for me.
The example has a straight forward explanation, along with a packed workbook for you try out for yourself.
Hope this helps.
Thanks for the tip but I couldn't seems to use the parameter Sheet as a filter even after I tried removing it from your attachment file.
Could you give me more specific steps to how you used the parameter as filter?
Thank you so much!