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

Jerome W. on 16 Aug 2020 04:05:43

RE: Add a multiple columns sort feature

Please add this. I can't believe this hasn't been implemented yet. If at least Power BI was respecting the sorting used in the SQL query... but NO, it just uses its own arbitrary sorting.

Power BI User's profile image Profile Picture

Angela on 16 Aug 2020 04:05:39

RE: Add a multiple columns sort feature

Sorting is a basic feature that I utilize for reports. I find it hard to believe that Power Bi does not include this feature, while Excel and Access have the capabilities of multiple sorting for different columns. Please add this as an option within the "Sort by Column" feature so that we may sort multiple columns at one time. This is essential in creating reports.

Power BI User's profile image Profile Picture

Phil Curtis on 16 Aug 2020 04:05:39

RE: Add a multiple columns sort feature

Embarrassing when client stumbles on this and reconsiders investment, let alone it stops real data analysis. Matrix is too clunky to include multiple sorted columns, Table should be fine and can't see the big deal and enabling multi-column sorting. Fix this asap please, its a commercial project killer.

Power BI User's profile image Profile Picture

DaveG on 16 Aug 2020 04:05:21

RE: Add a multiple columns sort feature

Would be a very useful feature.

Power BI User's profile image Profile Picture

Daniel on 16 Aug 2020 04:05:17

RE: Add a multiple columns sort feature

For me it would be very useful
Please add this

Power BI User's profile image Profile Picture

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

RE: Add a multiple columns sort feature

I share the same problem and hence same requirement

Power BI User's profile image Profile Picture

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

RE: Add a multiple columns sort feature

I share the same problem and hence same requirement

Power BI User's profile image Profile Picture

Jay Fitchett on 16 Aug 2020 04:04:56

RE: Add a multiple columns sort feature

Convinced my manager we should switch from Qlik Sense to Power BI... The first thing she does when she gets into it is make a table and attempt to sort it. Oh wait - can't do that? What? Qlik Sense handles sorting quite well, while Power BI barely supports it at all. Don't get it.

Power BI User's profile image Profile Picture

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

RE: Add a multiple columns sort feature

Please add, this is an important feature for many use cases.

Power BI User's profile image Profile Picture

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

RE: Add a multiple columns sort feature

Such a basic feature - this really is essential.