?filter=Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'
This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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
Solved! Go to Solution.
@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
@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
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:
?filter=Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'
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'
@RobinS,
As my previous reply, it doesn't support to provide multiple values for same column in the report URL.
Regards,
Lydia
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.