Connect 2 different PBI reports by Drillthrough click

[akfir]

is there a way to connect two different PBI reports by the drillthrough button?
for example i have one report with customers basic data and by clicking on a customer it will take me to the other report with the sales data of the same customer.

please tell me it is possible and i dont have to be a programmer for that 🙂

Thanks!

[mahimabedi]

You should be able to do using cross report drill through. Very easy to set up similar to regular drill through. 

Step by step process described here:

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

Not mentioned in the doc, however in my experience it can be a bit finicky with the column names, so make sure the column names match in both report.

PS: Please mark this post as a "solution" and/or hit the "thumbs-up" button if it helps you. 

[Anonymous]

@akfir - Do you mean you have two pbix files or two reports in the same pbix?