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

ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

Anonymous It apperas you're filtering via query editor. Instead I would suggest you import all then filter via page-level or report-level filter.

Diego-mx's avatar
Diego-mx
Advocate I
8 years ago

Because of how my data is loaded, I don't agree with this. 
The table from the query editor is large enough to take several seconds.   So every operation on it takes longer, and thus it is better for me to filter it the earliest possible to reduce the wait time. 

Just commenting to consider such situation.