Skip to main content

Power BI

New

Sort and filter tables

Vote (57) 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

420143fe 989d-4604-914e-2bf52ac48387 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

39c7ddcc 1135-4ba1-a73e-20d1427ca586 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

fd957dca 82ff-4dd1-bf07-d096b9e89deb 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

cbece431 f579-437a-a67f-1e4f1dbba62e 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

69f78d32 b61e-4b6a-a8cc-9c8e5bbe8430 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

b5e35a47 3e1a-41fc-b812-411a49f78fdf 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)