Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
THanks JSH. Can we have pass existing report level filters to external report without adding to query ?
Thanks
Vivek
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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |