?filter=Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'
Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 9 | |
| 8 | |
| 7 | |
| 5 | |
| 5 |