Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to use or operator in URL filter

Hi all,

 

i was trying to use or operator in my url filter but it didn't work and this is weird becasue i can easily use and operator in url filter.

Here is my url filter and i passed to url ?filter=DwhStatusReport/Origin in ('Jabil') or DwhStatusReport/Factory Location in ('Greenbox') this filter. DwhStatusReport is my table. Origin and Factory Location two different columns in that table.

 

https://app.powerbi.com/groups/29814000-1735-4380-8ad3-c20b00012d5/reports/b05756e5-59db-4189-8023-a178ee22f3ec/ReportSection?filter=DwhControlNumberStatusReport/Origin in ('Jabil') or DwhControlNumberStatusReport/Factory Location in ('Greenbox')