Power BI

Completed

Add a multiple columns sort feature

Vote (4034)

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)

Comments (248)

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 on 16 Aug 2020 04:19:06

RE: Add a multiple columns sort feature

c'mon, this should be thing!

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?

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

RE: Add a multiple columns sort feature

Please, I need this! ;)

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