?filter=Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'
Forum Discussion
URL filter / Multi filters from same column
Hello,
I am passing a URL filter:
?filter=CDR/Reg eq 'one'
this works great
but
when i want to applie a second filter to same column, the report wont filter:
filter=CDR/Reg eq 'two' and CDR/Reg eq 'two'
please advise
thanks
- Anonymous8 years ago
RobinS,
It is not possible to pass multiple filter values for same column as you describe in the report URL. Please take a look at the following article about how to filter a report.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-url-filters/
Regards,
Lydia
3 Replies
- AnonymousNot applicable
RobinS,
It is not possible to pass multiple filter values for same column as you describe in the report URL. Please take a look at the following article about how to filter a report.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-url-filters/
Regards,
Lydia- RobinSFrequent Visitor
thanks for your response.
the page ref you provide works great if you are calling from two diff column in the same schema.
but if i want to filter two items from same column, it dosn't work.
the code you provided looks like this:
which works well.. np
but if i try this, the code dosn't work.. please notice i am calling from same column twice.
?filter=Store/Territory eq 'NC' and Store/Territory eq 'SC'
- AnonymousNot applicable
RobinS,
As my previous reply, it doesn't support to provide multiple values for same column in the report URL.
Regards,
Lydia