How to have multiple column sorts in Power BI desktop/online with directquery

sorting powerbi powerbi-embedded columnsorting powerbi-datasource
ivric picture ivric · Dec 15, 2017 · Viewed 11.4k times · Source

I have matrix visualization with multiple columns say:

ProjID ProjName Budget Proj_Status project_duration

I want to do a multiple column sort (like in Excel) first on Budget then on Project_duration in Power BI.

Answer

point71echo picture point71echo · Mar 29, 2018

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

You must comma-delimit each column header and ordering option within curly braces.

Example:

{{"1st_Sorted_Column_Header",Order.Ascending},{"2nd_Sorted_Column_Header",Order.Descending},{"3rd_Sorted_Column_Header",Order.Descending}}

Related questions

Custom sorting in PowerBI chart

Recently I came across one issue in which I need to show the column order as per my defined way in PowerBi report. Thing is, PowerBI sorts the columns in either Ascending(A->Z) or descending(Z->A) …

Read More
How do I sort a dictionary by value?

I have a dictionary of values read from two fields in a database: a string field and a numeric field. The string field is unique, so that is the key of the dictionary. I can sort on the keys, but …

Read More
Sort array of objects by string property value

I have an array of JavaScript objects: var objs = [ { first_nom: 'Lazslo', last_nom: 'Jamf' }, { first_nom: 'Pig', last_nom: 'Bodine' }, { first_nom: 'Pirate', last_nom: 'Prentice' } ]; How can I sort them by the value of last_nom in JavaScript? …

Read More