Filter a report using query string parameters in the URL - not working because of &

[evano_oruvan]

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] )&" ' "

[evano_oruvan · Accepted solution]

Solution:

SUBSTITUTE( MAX ( CurrentData[ASSET_NAME] ),"&","%26").

[v-mengzhu-msft]

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