add_advanced_filter
Add multi-condition And/Or filters to Power BI visuals, pages, or reports. Define up to two conditions per field using operators such as gt, contains, or isblank.
Instructions
Add an ADVANCED multi-condition filter (the And/Or advanced filter card) at a scope=visual|page|report: up to two conditions on the same field joined by And or Or. conditions = JSON array of {op,value} where op=gt|gte|lt|lte|eq|ne|isblank|isnotblank|contains|startswith. combine=and|or. fieldKind=column|measure, valueType=int|decimal|string. For scope=visual pass page+visual; scope=page pass page.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | page (scope=visual|page) | |
| field | Yes | the field | |
| scope | Yes | visual | page | report | |
| table | Yes | table that owns the field | |
| visual | No | visual (scope=visual) | |
| combine | No | and | or | and |
| fieldKind | No | column | measure | column |
| valueType | No | int|decimal|string | string |
| conditions | Yes | JSON array of {op,value} (1-2 conditions) | |
| reportSessionId | Yes |