Forum Discussion
multi column sort
How can we sort a table using two or more columns? I want to sort by fiscal year order first and then by size of deal next (large to small).
Tables only support single column sorting in Power BI. For multi column sorting, use matrix visual.
Thats unfortunate. Isn't there a work around using DAX and adding a third column to sort.
Hi Anonymous
Have a look at this post for a formula for a Rank based on two columns.
You could use a measure like this for sorting possibly.
Owen
