Can you provide a specific example (using screenshots) of the problem? I'm struggling to fully understand the issue.
Sure, can do. So the basic problem ist, that I use the same "Map" worksheet in two dashboards with Go To Sheet Actions between, but the selection is out-of-sync. I'd like two have maps in both dashboards that can be used to filter regions and stay synced with their selection.
Start on dashboard "Market Overview", click on "Region East"
Go To Sheet & Filter Action trigger, auto-switch to Dashboard "Market Detail"
Please note the dealer list on the right side: They are filtered by region (e.g. Region East contains Dealer 21 - Dealer 40)
The map on the left doesn't show any Region Filter, although it is the same map (work sheet "Map") on both dashboards.
Select any other region on the map in dashboard "Market Detail"
Dealers get correctly filtered according to the selection of the map ("Region Central" contains Dealers 41-60)
De-Select "Region Central" to remove all Region filters from the map:
Dealer list is now correctly filtered to the corresponding map selection (none) --> showing top 10 dealers from all regions (full market because no region is selected) -> compare dealer ids to first list.
If you now switch back to the "Market Overview" dashboard, there is still the initial selection of "Region East"
So the two maps are out of sync with their selection, although it uses the same worksheet and the filtering works correct (or as intended)
This is the filter setting: