You may achieve some of your goals
by using the result of a Filter Action --
a Set created by Tableau on-the-fly --
as a Filter on both Dashboards.
Please find the attached as an example.
Please note that if there are different datasources
on dashboards, there is no working solution for version 9.x --
but using a Cross-Datasource Filter (new in version 10)
you may have finally get it, too.
SyncTwoDashboards_YF.twbx 6.8 MB
Yuri, that's awesome! I have never seen an action work between sheets like that. I like it. The only issue is that once you've selected a state on the first sheet, you have to go back to the first sheet to filter to second. Still, super useful!
Amy, I would add that above you group filters and actions, and they are different things that have different effects on your dashboards. One quick change you could make is that in filters, you can make the data apply to all sheets using that datasource (click on the little arrow on top of the filter on your dashboards, and select "Apply to sheets", then "all sheets using this datasource"). This way when anyone selects a state from either dashboard through the filter, both will change.
I know it's a little bit of a nuisance, but I would almost advise going away with the action filter on state, putting the state name in the tooltip, and then forcing the user to user a filter (maybe wildcard would be most convenient).
I'm also a little confused what you mean by requirement 6; if you are concerned about not being able to select a different state once it's selected, then this filter issue should resolve it still. Again, I know it's a bit of a pain to take away the action filter, but given the importance of syncing between dashboards (and being able to change the filters on every dashboard), it's what I would go with.
SyncTwoDashboards.twbx 6.7 MB
Thank you Yuri. Sorry it took so long to respond but I have been out of the office.
I looked at your workbook but it is still not doing what we wanted regarding the map. We don't want the map to be filtered based on the Action(state).
Our data does not contain all the states but we want those states always colored on the map but have a state "highlighted" like my images in my original posts. The images in my original post has all states colored but the same concept.
Thank you Katie. Sorry it took so long to respond. I have been out of the office.
The key requirement was to click on a map and have the data filter on both dashboard. This part is easy. However, it is having the second dashboard to also filter the first dashboard with a map that's the tricky part and doesn't seem to be possible.
I basically need both dashboards have the same data let say by a state however the map on first dashboard need to contain all the states with the states in question either highlighted/selected but not filtered.
One other idea that may work that I didn't think of earlier is to "hide" all the sheets from the first dashboard in the second, and vice versa. In the past, I've added these sheets as floating, and made them 1x1 on the dashboard. I've included them in all action filters/filtering, and that way, when you move to the second dashboard, all the sheets are already filtered. It should also work in reverse with this technique.
Hope this helps!