Skip to main content

Power BI

Completed

Add a multiple columns sort feature

Vote (4034) Share
Power BI User's profile image

Power BI User on 23 Dec 2015 22:09:02

If it is possible please provide the multiple columns sort . For example I want to sort the table visualization based on Priority and severity

Administrator on 18 Dec 2020 23:57:00

This has been implemented for tables as of March 2020: 

Power BI Desktop March 2020 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI

We're well aware, however, that more can be done to improve its discoverability--as well as to extend support for the feature to other visuals (like the matrix). Keep an eye out for future developments! 

Comments (248)
Power BI User's profile image Profile Picture

Mohit Mahendra on 16 Aug 2020 04:20:18

RE: Add a multiple columns sort feature

Much needed please. Sorting by months across years is very much needed.

Power BI User's profile image Profile Picture

gnibailau on 16 Aug 2020 04:20:18

RE: Add a multiple columns sort feature

Yes!! Sorting by multiple columns will be very useful

Power BI User's profile image Profile Picture

Nik Power BI User on 16 Aug 2020 04:20:05

RE: Add a multiple columns sort feature

as requested earlier, this should also be a feature for multi-column sorting for matrix visual.

Power BI User's profile image Profile Picture

Mark Patel on 16 Aug 2020 04:20:02

RE: Add a multiple columns sort feature

Not to mention that we should have the flexibility to select the sort order of each column as ascending or decending order.

Thank you!

Power BI User's profile image Profile Picture

Jonathan Thomson on 16 Aug 2020 04:20:02

RE: Add a multiple columns sort feature

Now that you've done this for tables, do this for matrices as well, it's unbelievable you've sorted one and not the other

Power BI User's profile image Profile Picture

Gami Herrera on 16 Aug 2020 04:19:52

RE: Add a multiple columns sort feature

please add for the next release

Power BI User's profile image Profile Picture

Ross Power BI User on 16 Aug 2020 04:19:41

RE: Add a multiple columns sort feature

This is a basic Pivot Table function, please add to PowerBI without having to create special counting columns

Power BI User's profile image Profile Picture

Gary Thomann on 16 Aug 2020 04:19:24

RE: Add a multiple columns sort feature

Hierarchical sorting mechanism needed in visuals ...
Work around is add a numeric column to dummy up the sort. ie 3 tier sort the column would be nnn format where each position relates to each tier. Also need a way to hide this special sorting column

Power BI User's profile image Profile Picture

Brad Jones on 16 Aug 2020 04:19:23

RE: Add a multiple columns sort feature

This should be a standard feature.

Power BI User's profile image Profile Picture

User Name on 16 Aug 2020 04:19:13

RE: Add a multiple columns sort feature

Yep we need this. Sorting in Power Query editor isn't the best either, not when the table visual contains fields from multiple tables. Unless I have to restructure my things and merge queries in Power Query, JUST to sort by date, then a column, then another column...