url filter not working because of & HELP PLEASE

[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").

[Anonymous]

Hi @evano_oruvan ,

Power BI Report Server does support URL filter. Try something like this:

https://reportserver/reports/powerbi/YourReport?rs:Embed=true&filter=Occurrence/Occurrence_x0020_Type eq 'Custody'

Reference: Filter a report using query string parameters in the URL

• Power BI Report Server also supports the ability to specify additional filters using the “filter” URL parameter. Here's an example of what the URL might look like in Power BI Report Server: https://reportserver/reports/powerbi/Store Sales?rs:Embed=true&filter= Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'

I have also found a similar post, please refer to it to see if it helps you.

Solved: URL Filtering Not Working - Microsoft Power BI Community

• The article syntax states ?filter; however, &filter is the correct syntax.

Best Regards

Community Support Team _ Polly

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