topic URL Parameters from one Report to another in Report Server

URL Parameters from one Report to another

Anonymous — Tue, 05 Nov 2019 20:29:01 GMT

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!

Anonymous — Thu, 07 Nov 2019 17:30:33 GMT

I found this video

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'.