have multiple tables related each other and created from the same source, once a row is selected

[Anonymous]

have multiple tables related each other and created from the same source, once a row is selected in one table then remaining tables are filtering out.  I want fix the selected row, as soon as i select the item in the second table remaining are resetting.  My selection to be fixed in the selected table and the remaining to be changed based on the earlier selected tables.  Please help.

Example:

T1:                 T2:                T3:             T4:                     T5:

January          Sales            South         Electronics        Total

Febraury        Expenses      North         Electric              Avg

March            Misc             East            Grosseries        Tax

April                                   West           Pulses               Profit

May                                                       Organic

June

July

Once i select Month in T1, remaining will be changed.  Next I should be select item in T2 then the item in T1 shouldnt be changed but T3, T4, T5 should be changed. Once if i select item in T3, item in T1 and T2 shouldnt be changed but items in T4 and 5 should be changed.

Please help me.  Thanks

[v-jayw-msft]

Hi @Anonymous ,

Please check the Edit Interaction feature.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions 

In your case, you will need to turn on the interaction of other all tables for table1, turn on the interaction of other tables except table1 for table2, turn on the interaction of other tables except table1 and table2 for table3, and so on.

Best Regards,

Jay

[lbendlin]

That totally depends on how your data model is wired. Can you show your data model?

[Anonymous]

Hi Ibendlin,

Thank you very much for coming forward to help me, i was not able to upload pbix file or excel so please find the details below.

Thanks

SureshData in ExcelData in powerbi after uploadingView in powerbiClicked on ID 2Clicking on February, all data has been reset