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

Matthew Harris on 16 Aug 2020 04:16:08

RE: Add a multiple columns sort feature

I was enjoying a nice Shiraz by an open fire when my children ran into the drawing room screaming, they revealed that upon attempting to catalogue and analyse their insect collection they were unable to sort through multiple columns within power bi. Please add this feature, for the sake of the children. Please think of the kids!

Power BI User's profile image Profile Picture

Laricchiuta Francesco on 16 Aug 2020 04:16:07

RE: Add a multiple columns sort feature

It's really really necessary.

Power BI User's profile image Profile Picture

Mike G on 16 Aug 2020 04:15:59

RE: Add a multiple columns sort feature

Would like a Multi- Column / Advanced Sorting Option. Trying to look at freight expenses than by Sales Number of Sales Orders, but not allowing me to do what I want without the advanced sort option.

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 04:15:44

RE: Add a multiple columns sort feature

Please add multi level (or column) sort capability to power bi.

Thanks!

Power BI User's profile image Profile Picture

miguel on 16 Aug 2020 04:15:44

RE: Add a multiple columns sort feature

Would also be nice to be able to custom sort columns and rows (e.g. by dragging column/row label in a desired order)

Power BI User's profile image Profile Picture

Sriram on 16 Aug 2020 04:15:36

RE: Add a multiple columns sort feature

Another must have feature, come on guys , still under review. What is there to review. Please start the work

Power BI User's profile image Profile Picture

Ric Lee on 16 Aug 2020 04:15:29

RE: Add a multiple columns sort feature

Need it Quick ! and Fast !

Just need to update Table and Matrix Visual component, it should solve 99%.

and leave the rest on power query. (build keys, use of keys.. etc)

Power BI User's profile image Profile Picture

selectSt4r on 16 Aug 2020 04:15:26

RE: Add a multiple columns sort feature

The best workaround I have found thus far is to use the DAX function "ISONORAFTER".
Reference: https://community.powerbi.com/t5/Desktop/Sorting-by-multiple-columns/m-p/536884#M251918
Function Details: https://docs.microsoft.com/en-us/dax/isonorafter-function-dax

Power BI User's profile image Profile Picture

Jens Aage Pedersen on 16 Aug 2020 04:15:22

RE: Add a multiple columns sort feature

I agree, it is simply unbelievable that this basic and essential feature isn't readily available.

Power BI User's profile image Profile Picture

Tim on 16 Aug 2020 04:15:17

RE: Add a multiple columns sort feature

I can't describe how frustrating it is not to have this seemingly straightforward capability. I'm scouring the internet and struggling to come up with a workaround and I can't get anything to work. Pretty please make this happen!