Narendra 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 19 Apr 2024 08:31:48
This is in our backlog. Please vote to receive updates as we make progress.
- Comments (248)
RE: Add a multiple columns sort featue
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 featue
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 featue
Much needed for reporting production on bank reports.
RE: Add a multiple columns sort featue
A much needed feature
RE: Add a multiple columns sort featue
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 featue
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 featue
A must have and hoping for it to happen this year.
RE: Add a multiple columns sort featue
Unbelievable that it's not already there, always embarrassing explaining to clients that this isn't possible
RE: Add a multiple columns sort featue
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 featue
'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}})