This is difficult because a filter on 'India' would exclude all other countries in the APAC region. You might be able to do this with a Level of Detail calculation, but it will depend on the structure of your data and what's available.
Please attach a Tableau Packaged Workbook.
I have implemented it successfully with the data model changes. At a high level - it is to have both 'country' and 'region' in one column - for each set of values we need to display on the chart.
See values in 'hierarchy' column, this field is displayed on the chart, whereas when we select 'D1' from 'filter column' it now displays both 'D1' and its corresponding region 'R1'.
The key is to aggregate the data in this format.
filter column type hierarchy dealer country region loyality score YEAR D1 Dealer D1 D1 C1 R1 L1 30 2010 D1 Dealer D1 D1 C1 R1 L2 20 2010 D1 Dealer D1 D1 C1 R1 L3 50 2010 D1 Dealer D1 D1 C1 R1 L1 20 2011 D1 Dealer D1 D1 C1 R1 L2 50 2011 D1 Dealer D1 D1 C1 R1 L3 30 2011 D1 Region R1 D1 C1 R1 L1 30 2010 D1 Region R1 D1 C1 R1 L2 20 2010 D1 Region R1 D1 C1 R1 L3 50 2010 D1 Region R1 D1 C1 R1 L1 20 2011 D1 Region R1 D1 C1 R1 L2 50 2011 D1 Region R1 D1 C1 R1 L3 30 2011
Generally I achieve this by having the two different 'Geography' options in the same column. I.e. a data structure as below. The problem with the way your data is structured is that you're trying to show two different dimensions as if they are the same dimension.
Year Geography Metric Value 2010 India Red 69 2011 India Red 12 2012 India Red 93 2010 APAC Red 9 2011 APAC Red 83 2012 APAC Red 83 2010 India Yellow 85 2011 India Yellow 57 2012 India Yellow 27 2010 APAC Yellow 88 2011 APAC Yellow 87 2012 APAC Yellow 92 2010 India Green 42 2011 India Green 58 2012 India Green 56 2010 APAC Green 89 2011 APAC Green 69 2012 APAC Green 59
I'm not sure if you're familiar with SQL or not, but I normally create a dataset like above by using a UNION statement to fetch the two differently levels of aggregation.
I've also attached a Tableau Packaged Workbook (Tableau 9.3) to demonstrate how it works once you've got it in Tablau.
combinedgeo.twbx 10.2 KB