Forum Discussion
Filter a report using query string parameters in the URL - not working because of &&
This is my column name and value below.
| ASSET_NAME |
| mats&service |
Below is the dax code i use to get data from table and create a link to filter the my page, but it wont work when value(mats&service) in column(ASSET_NAME) has & in it, the link gets terminated at & like this
https:/app.powerbi.com/?filter/somerandomtextand%20andthesemats
and the filter wont work, can someone help me escape this & so that value is accepted and filtered in my page,
RawData =
MAX ('Raw data'[Raw Data])&"?filter=Table/ASSET_NAME eq"&" '"
& MAX ( CurrentData[ASSET_NAME] )&"' and Table/LEVEL1 eq"&" '"
& MAX ( CurrentData[LEVEL])&"' and Table/DOS_NO eq"&" ' "
& MAX ( CurrentData[RULE_NO] )&" ' "
Solution:
SUBSTITUTE( MAX ( CurrentData[ASSET_NAME] ),"&","%26").
2 Replies
- AnonymousNot applicable
Hi evano_oruvan ,
please refer to this image and the correspending doc
Filter a report using query string parameters in the URL - Power BI | Microsoft Docs
Hope this can help you.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- evano_oruvanFrequent Visitor
Solution:
SUBSTITUTE( MAX ( CurrentData[ASSET_NAME] ),"&","%26").