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 (249)
RE: Add a multiple columns sort feature
Yep we need this. Sorting in Power Query editor isn't the best either, not when the table visual contains fields from multiple tables. Unless I have to restructure my things and merge queries in Power Query, JUST to sort by date, then a column, then another column...
RE: Add a multiple columns sort feature
Any updates on when we can expect this?
RE: Add a multiple columns sort feature
c'mon, this should be thing!
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?
RE: Add a multiple columns sort feature
Please, I need this! ;)
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
RE: Add a multiple columns sort feature
Wait wait... Damm why Power BI Team Why.. ?
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.
RE: Add a multiple columns sort feature
It would be perfect for end-users analysis. Congrats by this idea.
RE: Add a multiple columns sort feature
Halp this is such a PIA