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

Power BI User on 16 Aug 2020 03:53:50

RE: Add a multiple columns sort feature

Totally agree. The 'solution' of creating a calculated column and sorting by that (similar with joining using multiple columns) is not really good enough.

Power BI User's profile image Profile Picture

Corne on 16 Aug 2020 03:53:49

RE: Add a multiple columns sort feature

I have several reports created where it would be nice to sort on multiple columns. For example (1) number of orders decreasing year and month or (2) seqenced by weeks the number of tickets for each department in decreasing volume.

Part of this want is that the multi column sort is very flexible in MS Excel

Power BI User's profile image Profile Picture

Amin Hussani on 16 Aug 2020 03:53:35

RE: Add a multiple columns sort feature

I agree with other comment, at least excel features should be part of Power BI.

Power BI User's profile image Profile Picture

Holly Jahangiri on 16 Aug 2020 03:53:28

RE: Add a multiple columns sort feature

There are many very BASIC features that are not supported by Power BI. This is one of them. I don't think we should even have to vote on something this simple and straightforward - it's a feature of Excel.

Power BI User's profile image Profile Picture

Darren Donhardt on 16 Aug 2020 03:52:51

RE: Add a multiple columns sort feature

Yes please, do add. Looking at migrating functionality from COGNOS impromptu to Power BI Desktop and this is important

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 03:52:34

RE: Add a multiple columns sort feature

Need to order by store, date. Very much needed feature.

Power BI User's profile image Profile Picture

Frederico on 16 Aug 2020 03:52:00

RE: Add a multiple columns sort feature

Would be really Nice. I need to sort by Company and Year

Power BI User's profile image Profile Picture

Pavan on 16 Aug 2020 03:51:59

RE: Add a multiple columns sort feature

This feature is very much required