topic Re: How to filter 2 different columns using "OR" in Power BI Embedded with JS in Developer

How to filter 2 different columns using "OR" in Power BI Embedded with JS

gluizqueiroz — Wed, 19 Nov 2025 20:10:10 GMT

const basicFilter = { $schema: "https://powerbi.com/product/schema#basic", target: { table: "Store", column: "Salesperson" }, operator: "In", values: [202], filterType: models.FilterType.BasicFilter, requireSingleSelection: true }

Im using this type of filter when embedding a Power BI Report using JS API.
Now, I filter the column "Salesperson" only, from table "Store".
But now, I need to change this, I need to do this following logic:

Table: Store Column: Salesperson Values: [202] OR Table: Store Column: Manager Values: [202]

Because, the user = 202, has registers when he was "salesperson" and registers when he was "manager" and I need to show both results.
How can I achive this "OR" in Power BI Embedded API JS?

Re: How to filter 2 different columns using "OR" in Power BI Embedded with JS

lbendlin — Wed, 19 Nov 2025 20:50:01 GMT

Create a calculated column [SalesPerson] & "|" & [Manager].

Use PATHCONTAINS with your search criteria.

Re: How to filter 2 different columns using "OR" in Power BI Embedded with JS

v-venuppu — Fri, 21 Nov 2025 12:38:56 GMT

Hi gluizqueiroz ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you lbendlin for the prompt response.

You can apply an OR filter across two different columns in Power BI Embedded by using an Advanced Filter. Basic Filters only allow filtering one column at a time, but Advanced Filters support combining conditions with OR logic.

In your case, you would create one advanced filter that contains:

Condition 1: Store[Salesperson] = 202

Condition 2: Store[Manager] = 202

Logical operator: OR

When applied, the report will show all rows where the user is either a salesperson or a manager, without needing any changes to your data model or calculated columns.

Re: How to filter 2 different columns using "OR" in Power BI Embedded with JS

v-venuppu — Mon, 24 Nov 2025 07:18:04 GMT

Hi gluizqueiroz ,

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

Re: How to filter 2 different columns using "OR" in Power BI Embedded with JS

v-venuppu — Thu, 27 Nov 2025 06:35:33 GMT

Hi gluizqueiroz ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.