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

Jans on 16 Aug 2020 03:58:10

RE: Add a multiple columns sort feature

Please add this.

Power BI User's profile image Profile Picture

yvettem on 16 Aug 2020 03:58:01

RE: Add a multiple columns sort feature

In matrix visual: First sort by field 1 and then by field 2 etc - this is an essential requirement! E.g. First sort by Total, then by month. Thanks.

Power BI User's profile image Profile Picture

Sunny on 16 Aug 2020 03:57:37

RE: Add a multiple columns sort feature

Please add this feature. It would be really really helpful!!

Power BI User's profile image Profile Picture

Luc van de Plas on 16 Aug 2020 03:57:29

RE: Add a multiple columns sort feature

Even Excel knows this functionality. :-) It would be a very nice to have when sorting on yearweeknumber.

Power BI User's profile image Profile Picture

Joviee on 16 Aug 2020 03:56:38

RE: Add a multiple columns sort feature

Need this too!

Power BI User's profile image Profile Picture

Dave on 16 Aug 2020 03:56:32

RE: Add a multiple columns sort feature

Please, I need this

Power BI User's profile image Profile Picture

Keith Dickson on 16 Aug 2020 03:56:30

RE: Add a multiple columns sort feature

Adding to the chorus for inclusion of multi-column sorting (for either table visualizations or underlying queries). This is a very basic reporting task which is trivial to do in Excel or SQL. I am shocked to find out it is not possible in Power BI. My Fortune 500 organization is evaluating Power BI for possible use at an enterprise level, but this sort of deficiency precludes full-scale adoption.

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 03:56:28

RE: Add a multiple columns sort feature

Please add this.

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 03:56:26

RE: Add a multiple columns sort feature

Please add this feature ASAP. It's really needed.

Power BI User's profile image Profile Picture

osinquinvdm on 16 Aug 2020 03:56:10

RE: Add a multiple columns sort feature

This is called Advanced Sorting in most BI tools. It usually opens a pop-up window where you can select the first column you want to sort on on and the associated sorting order.
Then you can add other columns you want to sort on next.
It should also give you the possibility to move columns up and down to manage the order in which the sorting should be applied