Filters not working in Power Query

[AnushaAv]

Hello All,

I have a strange issue here. I have imported an Excel sheet and performed "Unpivot Select Columns" on few columns. Once unpivoted, I tried to filter the rows on the "Attribute" column (which will have the list of column headers before unpivot) by some value. The drop-down of that filter is showing the value( shown in pic 1), but when I apply filter based on that value, no rows are being returned(shown in pic 2). It's showing "This table is Empty" message. Can someone please help here? 

[v-juanli-msft]

Hi @AnushaAv 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft]

Hi @AnushaAv 

As tested on my side with last version,

It works to filter the column after unpivot selected columns.

Please check the version and update to the lastest one,

share some example data or code in Advanced editor so i can make a test.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Is that the only filter you have applied and is what you show the last step in your query?