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

[v-yangliu-msft · Accepted solution]

Hi  @evano_oruvan ,

You can try the following forms:

xxx?filter=Tablename/ASSET_NAME eq 'mats%26service'

Refer to：

Filter a report using query string parameters in the URL - Power BI | Microsoft Docs

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.