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
Thank you very much. I was working from the instructions in that link, but completely missed it had to link to a report.