I have a dashboard with a map of towns and a bar chart of the same towns. Both are colored according to the same measure, and the bar chart will be sorted descending on this value as well. I want the following to happen when you click on a town in the map or bar chart: 1. the town gets highlighted on the map; 2. the town does not get highlighted on the bar chart; 3. the town moves to the top of the list in the bar chart. I also want to allow multiple selections, and in particular multiple selections regardless of the source sheet. For example, if you click on a town in the map, then a different town in the bar chart, both should be highlighted in the map, and both should be moved to the top of the bar chart.
I attempted to do this using Set Actions, but it does not quite work. What I did was create a Set of town names, and a Set Action with the map and bar as source sheets. However, selecting towns on the map will add those towns to the set, and then selecting towns on the bar chart will add those towns separately to the set. See the following screenshots for an example:
1. Two towns select on the map, both are highlighted and moved to the top of the bar chart.
2.Two additional towns selected in the bar chart. The map highlighting is correct, but the set now only contains the two new towns (the first two towns selected from the map are no longer at the top of the bar chart). The desired behavior is that all four towns will also be at the top of the bar chart.
3.Selected an additional town on the map. The first two towns selected from the map are now at the top of the bar, and the two towns selected from the bar chart are not highlighted, and not at the top of the bar. The desired behavior is that all 5 towns will be highlighted on the map, and at the top of the bar.
Does anyone have any ideas for how to get the behavior I want? I feel like either I'm making some basic mistake, or there is a bug, because I can't imagine any scenario where you would want the behavior I'm seeing.
Attached is a twbx.
SetActionMultipleSheet.twbx 112.8 KB