Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Add a multiple columns sort feature

If it is possible please provide the multiple columns sort . For example I want to sort the table visualization based on Priority and severity
Status: Completed
Comments
ian_mcarthur1
New Member
every client..."what do you mean it can't sort by more than one column?" (embarrassed look away and clearing throat...)
Jeffrey_Berkey
New Member
'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}})
mzamora3
New Member
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.
jeremy_herbert
New Member
Basic reporting functionality - come on Power BI team, we need this!
ivanhajko
New Member
This feature is much needed one. I really don't like to do DAX workaround every time I want to sort by multiple columns
fbcideas_migusr
New Member
A much needed feature
grafiusjd
New Member
Much needed for reporting production on bank reports.
sundarr_gopal
New Member
Come on, you can do better! Have a table visual without multi column sort? Why do we need this visual, then?
gruss
New Member
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.
ryan_betway
New Member
Please add, this is an important feature for many use cases.