Query string Paramater in URL not working if column name contains " / " in it

[shubhamc_002]

HI Team, 

I am facing one issue while passing filter via URL using query string parameter. Table column contains / in it and have checked Microsoft Docs which suggested to use escape character for / which is %2F even after using this also its not accepting as filteration of data. 

Please advise if anyone having solution for this. 

Consider Table name  = Country

Column Name = State/SubDiv

Value = Test

eg: [appurl]+?filter=Country/State%2FSubDiv in ('Test')

Thanks

[shubhamc_002]

Hi @SwayamSinha , 

I have already referred this and based on information provided here , replaced / with %2F while building query in PBI report but its not working. 

Let me know if you have solution for this.

Thanks

[SwayamSinha · Accepted solution]

If you refer the document it says:

"When your query contains spaces, dashes, or other non-ASCII characters, prefix those special characters with an escape code starting with an underscore and an X (_x), then the four-digit Unicode, then another underscore"

So you need to have State_x002F_SubDiv instead

[SwayamSinha]

Have a look at this MS document :

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