Use filter from Page 1 in page 2 with different datasets

[Anonymous]

Hello,

we would like to achieve the following:

• We have a page 1 with a seperate dataset that contains a column called item
• I want to pick one item (used as a filter on page 1, which by the way has much more visuals and data) and use that item to jump to page 2, and use that item as a filter on a completely seperate dataset used in page 2 (like a variable brought over from page 1 to page 2, and use the variable as a filter on page 2 that has a completely seperate dataset)

Preferrably, I don't want to join these two datasets, but they both have item as a column, and I would like to use only one filter-record to be used to query dataset 2 aon a different page. More or less picking one value from dataset 1 and parsing that as a variable into dataset 2.

Is this possible? I know the drill-through capability, but I am not sure if you then need to join the two datasets in the PowerBI Data model. Is it possible to do so without joining, but parsing the filtered record (item) to another page with another dataset?

Regards,

Norman

[NusratShaikh]

Can you let me know if this resolved for differences datasets through drill through ?
I had the similar case but as it's not working for me

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Please refer to the online document about setting Cross- report drill through without joining two datasets.

https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through