Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

row filter with multiple clauses

Hi, I'm building a dashboard with a data set where I want to filter the rows down by multiple OR clauses. It appears to do so, however, when I apply the filter, it only retains the last two clauses....
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi kelbow,

     

    I agree with ankitpatira’s point of view, it seems more suitable than use query edit.

     

    Based on test, I can’t reproduce your issue, it works well, can you provide more info about this operation? Before you add filters, please check if there are records meet [OwnerLogin] = "officedev" or [OwnerLogin] = "onenotedev" or [OwnerLogin] = "onedrive".

     

    Test sample

    Power query formula:

    let

    Source = OData.Feed("services.odata.org/V4/Northwind/Northwind.svc"),

    Employees_table = Source{[Name="Employees",Signature="table"]}[Data],

    #"Filtered Rows" = Table.SelectRows(Employees_table, 

    each [City] = "London" 

    or [City] = "Redmond" 

    or [City] = "Tacoma" 

    or [City] = "Seattle" 

    or [Region] = "WA")

in

#"Filtered Rows"

     

     

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks. So...while I appreciate the pointer to those things, I guess that's not really my question. Where would I do that in PowerBI? The first topic gives me the syntax for filtering - which is nice...but literally - where would I do that in the PowerBI UI? The second topic, again, talks through how to do that with Power Query but, where do I find Power Query in PowerBI? Where would I do this in the UI on PBI desktop? Do I do this in the query editor? If so, is this a step I'm adding? I believe that's what I'm doing and I'm encountering this bug.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

 

About dax formula, you can use like this:

 

Filtered Table= CALCULATETABLE(Table,FILTER(Table,Table[Column1]="A"||Table[Column1]="B"||Table[Column1]="C"||Table[Column2]="D"))

 

For Power query filter multiple columns, you can follow below steps:

 

1. Open query editor and click the column's drop down button to open the menu.

 

2. Choose one option which belowe the filter to open the filter rows panel, select the "advanced" mode.

 

3. Add the filter conditions.

 

4. Click ok to general the power query formula, you can check it by open the advanced editor.

 

Regards,

Xiaoxin Sheng