Forum Discussion
Dynamic filtering URL issue
- 1 year ago
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.
So 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'
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.