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

Question

I had an matrix visulization with multiple columns such as 

ProjID ProjName Budget Proj_Status project_duration

and l want to sort them,How can I do this?

Answer 1

Use the following measures

= Table.Sort(#"Reordered Columns1",{{"OrdersCount", Order.Descending},{"OrderDate", Order.Descending}})

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

Check out the Power BI Developer blog to know how to become one.