Forum Discussion
Dynamic URL for different report pages in an APP
Hi :)
I have an APP that contains a report that has 4 images. The idea is that each image work as a link/url to a diferent page on another report on the same APP. Each of the link/url has a filter applied, so that when a user connect to the power bi service and access de report's APP just analyze relevant information.
I've created the url using a measure. For now it can filter the relevant data for each user but I'm still not able to define the destination page in the url.
Can anyone help me? Need to see a specific example.
Thank's in advance.
Kind regards,
LMFC
5 Replies
- v-xicai
Community Support
Hi Anonymous ,
You can refer to the links: https://docs.microsoft.com/en-us/power-bi/service-url-filters#filter-on-multiple-fields ,
https://www.kasperonbi.com/creating-a-hyperlink-with-filters-through-dax/ ,
https://www.cloudfronts.com/dynamic-url-filtering-power-bi/.
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
You can also refer to the similar case: https://community.powerbi.com/t5/Desktop/URLs-Power-Bi-Desktop/m-p/717338/highlight/false#M346191 .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Hi,
Thanks a lot for the fast reply.
The link that I created (in a calculated measure) has the following struture:
https://app.powerbi.com/Redirect?Action=OpenReport&reportObjectId=**reportidguid**&groupObjectId=**groupidguid**&reportPage=**ReportSectionName**?filter... //with the report filter that is currently working (https://docs.microsoft.com/en-us/power-bi/consumer/mobile/mobile-apps-deep-link-specific-location) (https://www.youtube.com/watch?v=8ASw-J0PuN8&ab_channel=GuyinaCube).
I just need to change de default page report when the user open the link. I don't know what to change on the link and where do I get the reference value for each different page of the report (the report is also published on the APP).
Best regards,
LMFC
- v-xicai
Community Support
Hi,
From the first link https://docs.microsoft.com/en-us/power-bi/service-url-filters#filter-on-multiple-fields, we know the dynamic URL filter have the structure : URL?filter=Table/Field eq 'value' , and it is different for reports in apps, you need to add " &'ctid=ctid " in the end, that will be the structure: URL?filter=Table/Field eq 'value' &'ctid=ctid .
If you need to filter report based on a measure, you can refer to the similar case : https://community.powerbi.com/t5/Desktop/URLs-Power-Bi-Desktop/m-p/717338/highlight/false#M346191 .
Or you could use the Filters pane on the report canvas instead of using dynamic URL filter.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.