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

Gion on 16 Aug 2020 04:17:05

RE: Add a multiple columns sort feature

This really needs to be completed soon.

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 04:16:42

RE: Add a multiple columns sort feature

Absolutely necessary, it is one of the basic feature for analytic tool to have

Power BI User's profile image Profile Picture

Sandra Frongillo on 16 Aug 2020 04:16:39

RE: Add a multiple columns sort feature

This is a simple sort that would solve a ton of formatting issues and calculations. Please add the sort option.

Power BI User's profile image Profile Picture

Power BI Ideas Admin on 16 Aug 2020 04:16:38

RE: Add a multiple columns sort feature

Very simple need

Power BI User's profile image Profile Picture

Dave Marchand on 16 Aug 2020 04:16:36

RE: Add a multiple columns sort feature

Looks like I get to join the crowd here asking why Microsoft why? This seems like such a basic and standard feature across many of your products but not in Powerbi? Being limited to one sort in a table is not cutting it, for me a Matrix is not going to work. As a work around I tried sorting my data in SQL first, it appears correctly in the query editor within Powerbi but then the table just ignores my order by reference. A few weeks ago my boss forwarded one our our Customers Tableau reports, I thought it was a logical choice to continue using a Microsoft products, based on the other software we use but I guess it is time to check out the competition.

Power BI User's profile image Profile Picture

Mitja Kavcic on 16 Aug 2020 04:16:36

RE: Add a multiple columns sort feature

Agree. Business needs this. We don't need to solve this on query level. It is on visual level for end users.

Power BI User's profile image Profile Picture

Ian Pinkett on 16 Aug 2020 04:16:35

RE: Add a multiple columns sort feature

QoL for end users is vital in moving towards report standardisation. It is impossible for me to ask people to move away from home brew excel solutions when basic functionality is lost. Admin please update on where things currently are with this. Tableau does not seem to have this issue.

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 04:16:31

RE: Add a multiple columns sort feature

Agreed - silly that this is available in Excel but not Power BI

Power BI User's profile image Profile Picture

Mohammed Suhel on 16 Aug 2020 04:16:28

RE: Add a multiple columns sort feature

when will you're going to be serious about user problem business want this feature, we need this badly, please get this ASAP we can't wait till next year MBAS for announcement than another few months for roll-out.

Power BI User's profile image Profile Picture

Jonathan Watters on 16 Aug 2020 04:16:20

RE: Add a multiple columns sort feature

to put it simply, this software should not be advertised as a complete solution if we can't even sort by multiple columns. mind boggling. this is hitting a 500 ft homerun and deliberately refusing to touch first base