multiple reports same sheet

[Anonymous]

Hi,

I have 3 datasets that I do not want to merge and I would like to visualize each of them as an independent report in the same sheet. For example insert a slicer that help me to change from one product to another. The slicer will show product 1,2 and 3. Let say I click on 1 (from table 1) I want to see all data related to this product (amount sale, who sale it, who purchase the product, etc), then if I click on product 2 (from table 2) see only data for this product and same with product 3. Hope you can help me! 

Thank you!

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may try to add a slicer table with product column. Then link it with other tables(1,2,3) like below. Then you may use the product column as slicer to filter all the tables.

 

Regards,

Cherie

[Anonymous]

Thank you!!!!!!