...
Create an empty string parameter, it’s going to be used as a variable so we’ll prefix to ‘v’: vRegion, and set an initial value of West
Create a filter calc fRegion set to the region, we’ll define as boolean as these evaluate the fastest: Region = vRegion
Now create a couple of charts:
First a Choropleth: Longitude to columns, Latitude to rows, Sum(Sales) to colour, State to the label, Region fRegion to the detailfilters selecting True
Next a bar: Region to the columns, Sales to the rows, fRegion onto the colours
Now a dashboard, drag both vizzes to the dashboard
Now is where the magic happens - we’ll set this so the choropleth zooms to the States in a selected region controlled by the bar chart:
Create a new dashboard action: Dashboard > Actions > Add Action > Change Parameter…In the dialogue:
Set the bar chart as the source
Run action on select
Target Parameter = vRegion
Field = Region
Press OK
...