?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 nowThe Fabric community is now in read-only for platform upgrade. Learn more
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
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.