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