URL filtering

[Anonymous]

Hello!

I have a problem with filtering from the URL. I found out that when in a report a value is selected by default in the slicer and when trying to filter the report based on another value for that slicer, not the default one, it just isn’t working.

Has anyone any ideas about it?

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

when trying to filter the report based on another value for that slicer：Do you mean that the url slicer filter doesn't work at this point?

See the official article for any relevant restrictions.

There are a couple of things to be aware of when using the query string parameters.

• When using the in operator, the values to the right of in must be a comma-separated list enclosed in parentheses.
• Power BI Report Server also supports the ability to specify more than one filter 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'
• Report URL filters have a 10-expression limit (10 filters connected by AND).
• The long data type is (2^53-1) due to JavaScript limitations.
• Power BI doesn't limit the number of characters in URL query strings. Different browsers have different length restrictions.
• You can't filter on table or column names that start with the capital letters INF, including, for example, a table name starting with "INFORMATION". Upper-case INF is a special value in OData. If you want to start a table or column name with "INF", make it lower-case "inf" instead.

And the following similar question you coul refer:

URL Filtering Not Working

URL with url filter not working

URL Filtering Not Working

And if question still not solved ,could you pls share your pbix file and remember to remove confidential data.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien