Forum Discussion
Filter a report using query string parameters in the URL - not working due to &&
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
- amitchandakSuper User
evano_oruvan , Are you trying something like this
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
- evano_oruvanFrequent Visitor
Solution:
SUBSTITUTE( MAX ( CurrentData[ASSET_NAME] ),"&","%26").