Forum Discussion
URL Filter not working
Hi imous,
If you want to filter the report in dashport using URL, you need to get the URL of your report instead of dashboard, like the following URL. A dashbord includes many reports, there is each URL per report.
https://app.powerbi.com/groups/me/reports/8d6e300b-696f-498e-b611-41ae03366851/ReportSection3
Then add the filter string: ?filter=Table/ColumnName eq 'value'. For example:?filter=Store/Territory eq 'NC', you will get:
https://app.powerbi.com/groups/me/reports/8d6e300b-696f-498e-b611-41ae03366851/ReportSection3?filter=Store/Territory eq 'NC'
Finally add a tile in dashbord, enter the Custom URL of a tile as follows! When you select the tile, it will show the filtered report.
Reference: https://powerbi.microsoft.com/en-us/blog/filter-a-report-with-a-url-query-string-parameter/.
Best Regards,
Angelia
Hi imous,
If you want to filter the report in dashport using URL, you need to get the URL of your report instead of dashboard, like the following URL. A dashbord includes many reports, there is each URL per report.
https://app.powerbi.com/groups/me/reports/8d6e300b-696f-498e-b611-41ae03366851/ReportSection3
Then add the filter string: ?filter=Table/ColumnName eq 'value'. For example:?filter=Store/Territory eq 'NC', you will get:
https://app.powerbi.com/groups/me/reports/8d6e300b-696f-498e-b611-41ae03366851/ReportSection3?filter=Store/Territory eq 'NC'
Finally add a tile in dashbord, enter the Custom URL of a tile as follows! When you select the tile, it will show the filtered report.
Reference: https://powerbi.microsoft.com/en-us/blog/filter-a-report-with-a-url-query-string-parameter/.
Best Regards,
Angelia
Hi v-huizhn-msft ,
We are deploying URL filters in Report A that are linking to various deployed apps. I am usins this syntax as recommended by the Microsoft documentation - app.powerbi.com/groups/me/apps/app-id/reports/report-id/ReportSection?filter=Table/Field eq 'value&'ctid=ctid
This works fine in Chrome-based browsers, but it has limited success in Edge. In fact, most of the time if fails in Edge and reroutes to app.powerbi.com (showing a blank page in the Power BI environment).
Do you any idea why this may be? Or recommendations to solve?
Thank you!
Jake