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)
RE: Add a multiple columns sort feature
We need a multilevel column sort for different hierarchies in MAtrix visuals.
I.e.
Sort by Rank on top hierarchie, for second hierarchie keep order according to rank but order second hierarchie according to highest value of that.
RE: Add a multiple columns sort feature
This feature is much needed one. I really don't like to do DAX workaround every time I want to sort by multiple columns
RE: Add a multiple columns sort feature
Much needed for reporting production on bank reports.
RE: Add a multiple columns sort feature
A much needed feature
RE: Add a multiple columns sort feature
Also: Allow to sort on non-displaying columns or measures.
Rationale for Multiple Column Sort feature: It's common to need different sort orders for visualizations that will only be used in a very small part of a report. As of now, to do so we need to create a measure or column.
It's bad software development practice to have to modify the data layer to accommodate a feature exclusive to the presentation layer. The existing practice is like declaring global variables and leaving them in scope everywhere.
Please, add this functionality at least to the base table view. It will go a long way towards simplifying our work with Power BI.
RE: Add a multiple columns sort feature
Come on, you can do better! Have a table visual without multi column sort? Why do we need this visual, then?
RE: Add a multiple columns sort feature
A must have and hoping for it to happen this year.
RE: Add a multiple columns sort feature
Unbelievable that it's not already there, always embarrassing explaining to clients that this isn't possible
RE: Add a multiple columns sort feature
Anyone who uses excel on regular basis comes to rely on multiple column sorts, so to not have this functionality in such a vastly superior tool as Power BI is really disappointing. Please add this asap.
RE: Add a multiple columns sort feature
'From the Query Editor, sort by one column then edit the formula to include the second column like this...
= Table.Sort(#"Reordered Columns1",{{"OrdersCount", Order.Descending},{"OrderDate", Order.Descending}})