'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}})
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.
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.