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

Kristyna Hughes on 16 Aug 2020 04:19:10

RE: Add a multiple columns sort feature

Any updates on when we can expect this?

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 04:19:06

RE: Add a multiple columns sort feature

c'mon, this should be thing!

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 04:19:03

RE: Add a multiple columns sort feature

Need to be able to sort by Year then Business Unit but the way I want it is not alphabetical. Why can't I drag/drop like in a pivot table?

Power BI User's profile image Profile Picture

Carlos Pesquera Nieto on 16 Aug 2020 04:18:31

RE: Add a multiple columns sort feature

Please, I need this! ;)

Power BI User's profile image Profile Picture

Daniel Adler on 16 Aug 2020 04:18:10

RE: Add a multiple columns sort feature

A kind request to embed the functionality of having a plain row number / index column that is not affected by sorting or anything in the visual, just goes from 1, 2, 3 and on

Perhaps scope creeping, but is dependent on column sorting and more or less impossible to create a dax for if there are several columns that can be sorted on i a table or matrix.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19331770-row-number

Would be great if it could be picked in the same go as it should only be a visual effect on the table and matrix.

Has to be done this complicated and crazy-work-aroundish way today:
https://community.powerbi.com/t5/Desktop/Rank-by-sorting-columns/td-p/729785
https://community.powerbi.com/t5/Desktop/Rank-a-column-in-a-table-based-on-slicer-selection/td-p/77705

Power BI User's profile image Profile Picture

Power BI Ideas Admin on 16 Aug 2020 04:17:32

RE: Add a multiple columns sort feature

Wait wait... Damm why Power BI Team Why.. ?

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 04:17:25

RE: Add a multiple columns sort feature

Good to see this is within the backlog!

Have up-voted to try and push through as quick as possible, very critical feature.

Power BI User's profile image Profile Picture

Power BI User on 16 Aug 2020 04:17:24

RE: Add a multiple columns sort feature

It would be perfect for end-users analysis. Congrats by this idea.

Power BI User's profile image Profile Picture

Andy Martin on 16 Aug 2020 04:17:24

RE: Add a multiple columns sort feature

Halp this is such a PIA

Power BI User's profile image Profile Picture

Juan Manuel Lacy on 16 Aug 2020 04:17:15

RE: Add a multiple columns sort feature

PLEASE!!!