Forum Discussion
Can I Filter reports using query string parameters in the URL for Power BI APPS multiple reports?
Hi there,
I have multiple reports in my workspace from which I create 1 Power BI APP for different users. All these reports (around 10) that are included in Power BI APP have the same filters/slicers for the customer selection (text type) and date slicers. I understand that for a better user experience it would be good to have 1 master/global filter that will work across different reports, instead of filtering each report separately.
I am wondering whether it is possible to create a "master filter report" and include it in APP and using as a global filter for another report within the APP.
I was able to achieve this with the example from the documentation https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters . But it is still unclear to me, whether I can and how if yes, to use query string parameters in the URL for filtering the data within the app for all reports.
Yes. Something like that. Hiding the default stuff and use custom links like the youtube example with the filter. Of course this is an approach, I'm not sure how set up navigation for the pages of the reports. It might help if the navigation for the report pages is inside the report pages. You might want to test it with a single report or two reports in a workspaces as a test/developer environment.
Regards
4 Replies
- ibarrau
Super User
Hi. No you can't generate a single App link that will keep the filter for all reports. The URL filter feature is by report. So it will only work for a single report. The only thing I think might do something similar would be building your own navigation links to reports in the app (instead of using the default navigator to reports). The links there can be already be URL modified with filters.
You need to go one by one the links of reaports, add the filter and then build the navigation. That approach might be similar of having a filter for the whole App.
I hope that helps,
Thank you very much for the prompt response. Can you please advise, whether the approach that you proposed is described in this article? https://powerbi.microsoft.com/en-us/blog/designing-custom-navigation-for-power-bi-apps-is-now-available/
- ibarrau
Yes. Something like that. Hiding the default stuff and use custom links like the youtube example with the filter. Of course this is an approach, I'm not sure how set up navigation for the pages of the reports. It might help if the navigation for the report pages is inside the report pages. You might want to test it with a single report or two reports in a workspaces as a test/developer environment.
Regards
