update second sheet data based on first sheet data selection

[Anonymous]

Hi

i have create a pie chart on sheet one which show region, on same sheet have some more visualization. when i select any region from pie chart than its impact all other visualization which show data of selected region.

now i have another sheet which also has some visualization. i want if i select region from pie chart on sheet one than data on sheet two also get update and show data based of selected region on sheet one. 

pls guide what is the way ,  where i know slicer only update current sheet data.

thx

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

We can create relationship between sheet1 and sheet2 based on region.

Then we can achieve your goal as below.

Pbix as attached.