So the only way I know how to do this is via Joe and Matt's brilliant sheet popping trick
So this is a bit fiddly to set up, but I have a working version of this in one of the models I made for a client...and works a treat (I also had 3 different pop options, not 2...which adds to the fiddly-ness, with 2 options it's fairly straight forward)
Hope that helps.
One option here is instead of having two sheets that are nearly identical, is to have the measure swap out on the same view. Then you only have one sheet and one filter to deal with.
Make a measure :
when 'Furniture' then sum([Sales])
when 'Technology' then COUNTD([Order ID])
use that on your table and on your filter and then you only have one sheet, one filter to worry about on the dashboard.
The downsides to this approach is you are limited to the same layout (so you can't swap from a line to a bar chart, for example), and the filter range is not going to swap automatically to appropriate context. So in the example file the scale between the two filters is pretty different. This means the users may have more tweaking on the filter every time they change the view, but it technically works.
Test.twbx 1.5 MB
Nice idea Justin,
And this won't work in every situation (I couldn't switch a Tile chart with a bar, say)...but by creating 2 measures you can also switch the chart-type.
Always lots of workarounds in Tableau!