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.
Hi Bavesh,
how you do multiple sorting with matrix?
Did you ever get a solution to sorting by multiple columns in a matrix?
is multiple sorting in a matrix possible without using dax workaround?
To sort fields in the Matrix Visual: Fields Icon > Drag individual fields to Rows
Turn on Subtototals (optional): Format Roller > Row subtotals > Apply to labels (On) > Per Row Level (On) > Choose On for field(s) to be included in Subtotal
