Forum Discussion

Twan's avatar
Twan
Icon for Advocate IV rankAdvocate IV
10 years ago
Solved

Filter Columns in Data View

Is there any way to filter columns when viewing a table in the data view in Power BI desktop?     In PowerPivot it is possible to filter each column when viewing the data in Data View.  This is use...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    Twan - I am not aware of a way to do this, you can right click a column and sort. Probably a good thing to post to Ideas if not there already.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Twan - I am not aware of a way to do this, you can right click a column and sort. Probably a good thing to post to Ideas if not there already.

Twan's avatar
Twan
Icon for Advocate IV rankAdvocate IV
10 years ago

Thanks Greg_Deckler,  I'll go look in the ideas section and see if anyone else has posted this idea and post it if nobody has.

 

I also figured out that you can go to the Home ribbon -> Edit Queries and it brings up a view similar to the data view where you can filter columns.  The only issue is that this view of the data does not contain calculated columns.