Filter a report using query string parameters

[revansh]

Hi All,

I want to pass multiple values as a filter in the URL:

below URL filters the report where STATE=KY

https://app.powerbi.com/groups/me/reports/reportid/ReportSection3?filter=country/state eq 'KY'

I want to pass 3 values like:

STATE in ('KY','OH','IN')

Thanks

[GilbertQ]

Hi @revansh

Currently the Service does not allow to pass multiple values in the query string.

The only work around is to concatenate values into new column, so all the values will then be stored in a single column.

Here is the blog post explaining how to achieve this.

https://powerbi.microsoft.com/en-us/blog/filter-a-report-with-a-url-query-string-parameter/

[revansh]

Hi Guavaq,

I want to send multiple values using a relational operator to the same table/column. Concatenation is a work around if we want to pass filters to multiple columns.

?filter=country/state eq 'KY' is working.... i want to filter for multiple states.

instead of eq , i want to use IN.

Thanks

[GilbertQ]

Hi there

Unfortunately that functionality is not available currently

[samarkhera]

Is it stil not there? Passing multiple filters in query string.