If I understand your question correctly your objective could be simply achieved using Filter > Apply to Worksheet > Selected Worksheet option. You could do this in a dashboard or in a worksheet , the result will be same regardless. Filter selection in one sheet will control the same filter present in others. Follow these steps and refer the attachment
1. Pull in the worksheet 1 and 2 in dash (Dashboard2).
2. Click on filter dropdown and select as shown here.
3. A window will open where you need to select sheets you want to control using this filter. And click OK.
4. When you publish and want to control filter in tabs from one of the tab, you can do so after the above set up.
Let me know if this helps.
HyperlinkTest.twbx 30.7 KB
Yep that completely makes sense. And filters works well when they are setup across all the worksheet. However, user wants to view Sheet2 as another window (so I used hyperlink action) when clicking Sheet3 (which is Click me). Then I loose the filters set in Sheet1. I was able to make it work when filters are implemented as parameters. But when creating URL action, I cannot pass Department value which if filter in Sheet3.