Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
Expand all | Collapse all

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

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

    Posted 21 days ago

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

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



    ------------------------------
    evano oruvan
    ------------------------------


  • 2.  RE: Filter a report using query string parameters in the URL - not working because of &

    Posted 20 days ago
    @evano oruvan,
    Try replacing the & with %26.   Just like spaces are replaced with %20, the ampersand has to be replaced with %26.

    Hope that helps.

    Kaz.​

    ------------------------------
    Kaz Shakir
    Sr. Program Manager, Asset Planning
    TN
    ------------------------------