Query Editor column filter does not work with mult...

Anonymous · ‎07-10-2016

Query Editor column filter does not work with multiple selections.

Single filter selection works fine.

Two or more filters does not work and only returns the last filter values.

I'm not certain if I am doing something wrong or if this is a limitation of Power BI Desktop. Any feedback would be appreciated.

Thanks.

Norm

ImkeF · ‎07-10-2016

There's no such limitation in PBI. The reason why only one value remains lies probably in the filters from other columns (like "Direction").

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Anonymous · ‎07-10-2016

Thanks for responding but that is not the case. The "direction" filter is not the root cause.

If it helps the source data comes from an OData feed.

Report and visualization filters work fine. It's Edit Query where it stops working.

Thanks.

Norm

Anonymous · ‎07-10-2016

I was able to workaround this by deselecting filter options from the bottom up, leaving the filter options that I needed. It stopped working after I deselected the filter option above the ones I needed. Using a text filter took care of those.

Very weird.

Thanks.

Norm

v-sihou-msft · ‎07-13-2016

@Anonymous

What's the version of yourPower BI Desktop? Please update the latest update.

I didn't encounter this issue in both June and July Update. I test with sample NorthWind Odata Feed (http://services.odata.org/V3/Northwind/Northwind.svc/ ). Rows can be filtered properly based on the selection in filter.

Regards,