subset of stores in chart based on store selection

[Anonymous]

I have a report that allows the user to select a store in a slicer. The data structure has store that are each a part of a region. Once a store is selected I want the chart to only include other stores in the region. For example say I have the following stores and regions. 

Region A: Stores 1, 2, 3

Region B: Stores 4, 5, 6

Region C: Stores 7, 8

Region 😧 Stores 9, 10, 11, 12

If the user selected store 5, then the chart would automatically refresh to show only stores 4, 5, and 6. 

Is this possible without a drill through scenario?

[v-chuncz-msft]

@Anonymous,

Simply duplicate the table, build relationship on [Region] column and drag store to Slicer.

Table =
Table1

[Anonymous]

@v-chuncz-msft

Can you elaborate on what you mean by build the relationship?