Forum Discussion
Helper IIIDynamic filtering URL issue
Hi krzysztof ,
The issue is with the URL structure. When adding extra parameters like filter=, you should use & to connect them, not another ?.
- There should be only one ? after /reportid.
- Additional parameters should be added using &, like &filter=....
If you want to create dynamic links for different EANs in Power BI, use a DAX measure. Display the links in a table visual and format them as Web URLs for easy access and clicks.FYI:
For more details, here the official Microsoft documentation you can refer
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
I hope this helps. If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
Super UserHi krzysztof ,
You’re definitely on the right track with dynamic URL filtering in Power BI, but there are a couple of things to double-check with the URL format:
First, make sure there’s only one question mark (?) after your report ID in the URL. After that, every additional filter or parameter should start with an ampersand (&). So, it should look something like this:
https://app.powerbi.com/groups/me/apps/.../reports/.../ReportSection?filter=YourTable/YourColumn eq 'YourValue'
If you want to filter by EAN (as a text field), your filter at the end would be something like:
?filter=DWH_MAGENES_V_DimMagenesStyleColors/EAN eq '5903698746425'
Just make sure any spaces in table or field names are replaced with %20, and everything matches the exact case and spelling used in your model.
To create fully dynamic links from another table, you can build the full URL in a DAX measure, referencing your EAN column. Then, display that DAX measure in a table visual as a clickable link, or use it with a button. If you want to take it a step further, you can even add page names or bookmarks to the URL (e.g., &pageName=ReportSection2) so users land exactly where you want after filtering.
If you’re still not seeing the results you expect after setting this up, double-check your data model relationships and make sure the column you’re filtering by is visible and correctly referenced in the target report.
krzysztofSo this is what the sample link would look like? If so, unfortunately it doesn't work:
https://app.powerbi.com/groups/me/apps/ac1fa691-e0ca-44a9-b373-6d713a9d5555/reports/3ab06284-3096-4b67-801b-57775508dae7/3202c5fdce77849db8d1?experience=power-bi?filter=DWH_MAGENES%20V_DimMagenesStyleColors/EAN%20eq%20'5903698746425'I marked the fragment with spaces:
DWH_MAGENES%20V_DimMagenesStyleColors/EAN%20eq%20'5903698746425'
V-yubandi-msftCommunity Support
Hi krzysztof ,
The issue is with the URL structure. When adding extra parameters like filter=, you should use & to connect them, not another ?.
- There should be only one ? after /reportid.
- Additional parameters should be added using &, like &filter=....
If you want to create dynamic links for different EANs in Power BI, use a DAX measure. Display the links in a table visual and format them as Web URLs for easy access and clicks.FYI:
For more details, here the official Microsoft documentation you can refer
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
I hope this helps. If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.