Forum Discussion

AnushaAv's avatar
AnushaAv
New Member
6 years ago

Filters not working in Power Query

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? 

 

 

 

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

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

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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