Team, I have a report page with drill through enabled for table when I right click one column it will drill through to four different pages in same report. Does there any way to drill through to different reports instead of pages ?
This is a difficult problem that has a limited solution. I've accomplished this by utilizing Query String filters and generating a dynamic web url from a measure. The problem is you can only use 'equals', so the passthrough filters have to be a bit static. https://docs.microsoft.com/en-us/power-bi/service-url-filters
Set the measure data category as web url, and add the link to your matrix/table.
_dmLink = // Measure VAR sReportUrl = "https://msit.powerbi.com/groups/04c8...3adce/reports/04c8...3adce/ReportSection"
VAR sColumn1 = IF(HASONEVALUE(SomeTable[SomeColumn]), "Query1/Column1 eq '" & MIN(SomeTable[SomeColumn]) & "' ", "")
VAR sLast6Weeks = " and Query1/Date_InLast6CalWeeks eq 1"
sReportUrl & "?filter="
Outputs something like this:
https://msit.powerbi.com/groups/04c8...3adce/reports/04c8...3adce/ReportSection?filter=Query1/Column1 eq 'SomeValue' and Query1/Date_InLast6CalWeeks eq 1