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 04:08:47

RE: Add a multiple columns sort feature

We need to sort for example by document number and second sort by doc details line ...

Multiple columns search is a basic need .

Power BI User's profile image Profile Picture

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

RE: Add a multiple columns sort feature

Was evaluating Power BI for 15 minutes and found this feature to be lacking. The current thread has been open for 2 years without the feature being implemented; this is crazy. Switching to another BI software now.

Power BI User's profile image Profile Picture

Anas on 16 Aug 2020 04:08:43

RE: Add a multiple columns sort feature

Yes, please!

Power BI User's profile image Profile Picture

Anas on 16 Aug 2020 04:08:43

RE: Add a multiple columns sort feature

yas please

Power BI User's profile image Profile Picture

Melissa on 16 Aug 2020 04:08:36

RE: Add a multiple columns sort feature

This needs to be something that is implemented! Currently working on a report that I need to sort by the year/month and the count of records. A nested sort option would solve this so easily!

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 04:08:36

RE: Add a multiple columns sort feature

Essential.

Power BI User's profile image Profile Picture

Janis on 16 Aug 2020 04:08:20

RE: Add a multiple columns sort feature

Yes, please!

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 04:08:18

RE: Add a multiple columns sort feature

This would be a good feature to have.

Power BI User's profile image Profile Picture

Ananda Kumar on 16 Aug 2020 04:08:15

RE: Add a multiple columns sort feature

The sorting done in Power Query (sorted by multple columns) is not maintained in the visuals. So the whole point of sorting during the ETL is lost when trying to do the visuals.
As much as the need for multple column sort in visuals it is equally important to maintain the sorting done during ETL using Power Query.
Made this comment in the below thread as well as it has more votes.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11185431-add-a-multiple-columns-sort-featue

These two threads should be combined and that will move this idea further up in votes.

Power BI User's profile image Profile Picture

Ananda Kumar on 16 Aug 2020 04:08:14

RE: Add a multiple columns sort feature

The sorting done in Power Query (sorted by multple columns) is not maintained in the visuals. So the whole point of sorting during the ETL is lost when trying to do the visuals.
As much as the need for multple column sort in visuals it is equally important to maintain the sorting done during ETL using Power Query.