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

So the steps you show are precisely the ones I am following. When I do that, the only results that show up are items that meet only 2 of the 5 possible groups. I'm trying to explain that there is a BUG when I do this.

 

This is not a solution. It's broken.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

 

Sorry for slowly resoponse, can you share me a sample to reproduce your issue? I will test on it.

 

Regards,
Xiaoxin Sheng