Forum Discussion
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')
or across fields is not a supported filter component. Frankly, it isn't supported in Power BI either.
Filter a report using query string parameters in the URL - Power BI | Microsoft Docs
1 Reply
- lbendlinSuper User
or across fields is not a supported filter component. Frankly, it isn't supported in Power BI either.
Filter a report using query string parameters in the URL - Power BI | Microsoft Docs