Skip to main content
Microsoft Idea

Power BI

Needs Votes

Sort and filter tables

Vote (58) Share
Andreas Balzer's profile image

Andreas Balzer on 10 Sep 2015 05:24:42

Tables in PowerBI Desktop should be filterable and sortable with the user interface known from Excel, a small icon at each column header.

Comments (6)
Andreas Balzer's profile image Profile Picture

VickyD on 05 Jul 2020 23:30:20

RE: Sort and filter tables

This is single most important feature that is preventing people from fully using our Power BI Reports. First thing everyone asks for is .. how can I export because Excel gives them that easily ability to filter columns which are for a lot of cases a key way to analyze data.
Dropdown slicers are great but only so many one can add and they take up a whole lot of space too. Please implement this!

Andreas Balzer's profile image Profile Picture

Power BI User on 05 Jul 2020 23:27:29

RE: Sort and filter tables

Filter in Column header would be very useful, please implement it

Andreas Balzer's profile image Profile Picture

Power BI User on 05 Jul 2020 23:26:04

RE: Sort and filter tables

This would be awsome to have. Redusing the need for Slicers on the report page

Andreas Balzer's profile image Profile Picture

Rasmus Kaas on 05 Jul 2020 22:57:10

RE: Sort and filter tables

And it would be convenient if tables could also be filtered (for viewing) in data view - just like in PowerPivot, (not only in query editor). Maybe this needs a separate entry.

Andreas Balzer's profile image Profile Picture

Power BI User on 05 Jul 2020 22:49:24

RE: Sort and filter tables

Yes, I agree. Ability to filter Matrix columns supplied by small icon at each column header is desireable.

Andreas Balzer's profile image Profile Picture

Miguel Llopis on 05 Jul 2020 22:06:50

RE: Sort and filter tables

This should also include the ability to sort by multiple columns (just like in Excel)