cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vivekrs Regular Visitor
Regular Visitor

Drill through to another report

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 ?

Thanks
Vivek
5 REPLIES 5
Highlighted
Super User
Super User

Re: Drill through to another report

Right now you cannot do that but I'm pretty sure that there are Ideas on it and I thought that perhaps it was either Planned or Started but I may be incorrect.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

jsh121988 Regular Visitor
Regular Visitor

Re: Drill through to another report

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" RETURN sReportUrl
& "?filter=" & sColumn1 & sLast6Weeks

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

 

 

vivekrs Regular Visitor
Regular Visitor

Re: Drill through to another report

THanks JSH. Can we have pass existing report level filters to external report without adding to query ?

 

Thanks

Vivek

vivekrs Regular Visitor
Regular Visitor

Re: Drill through to another report

Thanks JSH. It worked fine by passing selected value to url string to open external report. 

But this works for URL as separate column next to my measure as another column. Is there any way to show measure as hyperlink and when i click  i want to go to a hyperlink to open a external report?

 

Thanks

Vivek

 

 

jsh121988 Regular Visitor
Regular Visitor

Re: Drill through to another report

Hi Vivek,

 

I don't know if that is possible. I just enabled the Web Url icon for the link, and placed it to the right of the measure.

 

Thanks,

Jon

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 34 members 983 guests
Please welcome our newest community members: