Skip to main content
Microsoft Idea

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

Scott Lindsey on 16 Aug 2020 04:08:07

RE: Add a multiple columns sort feature

Power BI team - there are several requests for sorting on multiple columns. Can you advise if there is any thought being given to these requests?

The votes are somewhat scattered across multiple ideas, but there is some demand for this feature.

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 04:08:05

RE: Add a multiple columns sort feature

Multi Column Sort in each Visual is a must.

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 04:08:05

RE: Add a multiple columns sort feature

See Post from Anoymous, March 28, 2018 below. This is a good "band aid fix" until it is added by Power BI

Power BI User's profile image Profile Picture

Pablo Steyerthal on 16 Aug 2020 04:08:05

RE: Add a multiple columns sort feature

The Matrix visual needs ROW and COLUMN SORT by value and mutiple sorting. Not only a multiple sorting for columns

Power BI User's profile image Profile Picture

Shaun Gartland on 16 Aug 2020 04:08:04

RE: Add a multiple columns sort feature

This is a must for standard reporting

Power BI User's profile image Profile Picture

Beth on 16 Aug 2020 04:07:54

RE: Add a multiple columns sort feature

This is VERY needed.

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 04:07:35

RE: Add a multiple columns sort feature

Multi-Column Sort is a VERY much needed feature.

Power BI User's profile image Profile Picture

'@benjact on 16 Aug 2020 04:07:20

RE: Add a multiple columns sort feature

I came here looking for this capability when I am filtering TOP N in a matrix of historical data. It is nonsense sorting ascending for years and at the same time the TOP N items which in fact should be sorted descending

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 04:06:49

RE: Add a multiple columns sort feature

Multiple column sorting should be a must in all visuals where sorting is possible. Difficult to work with otherwise because you have to create a lot more joined columns to get what you need.

Power BI User's profile image Profile Picture

Stephen Hancox on 16 Aug 2020 04:06:44

RE: Add a multiple columns sort feature

Surely this should just be a basic fundamental feature