Forum Discussion
URL Parameters from one Report to another
Hi,
we are using PBIRS Sept 2019 version and we have 2 completely different reports.
Report 1 has Hyperlink to Report 2.
am looking for options to pass Slicer selections from Report-1 to Report-2 when user clicks on?
both are on PBIRS.
am finding documentation for Paginated Reports, Regular Power Bi but not Report Server.
How do I save and send/pass selections from Report-1 dynamically ?
Syntax: URL?filter=Table/Field eq ‘value’
Thank you!
1 Reply
I found this video
https://www.youtube.com/watch?v=8ASw-J0PuN8
Created a Measure:
FilteredURL = IF(ISFILTERED(Store[Territory]), “https://app.powerbi.com/groups/me/reports/beb3e658-8372-4bfe-8cb2-914287c75b62/ReportSection3?filter=Store/Territory in (‘” & CONCATENATEX(VALUES(Store[Territory]), Store[Territory], “‘,'”) & “‘)”)
But this is still incomplete: with this approach we can only display full web URL on the page which doesnt look good to the end user.
I wanted to pass this Measure to a Image/Action/Web URL.
or to a Text in a 'Text Box'.