Allow multi-column sorting in Table and Matrix visuals

Gepax — Fri, 20 Mar 2026 12:47:07 GMT

Description:
Currently, Table and Matrix visuals in Power BI only allow sorting by one column at a time. It would be extremely useful to support multi-column sorting, similar to an ORDER BY clause in SQL.

Practical example:
In a driver ranking table, I would like to:

Show first the drivers who have already reached the target, sorted by bonus achieved
Then show the drivers who have not reached the target yet, sorted by remaining value to target

Today, the only workaround is to create helper columns or DAX measures that combine multiple sorting rules into a single expression. While this can work, it makes the model more complex, less flexible, and harder to maintain.

Suggested improvement:
Allow Table and Matrix visuals to support multi-level sorting, for example:

1st sort: Bonus Achieved (descending)
2nd sort: Remaining Value (ascending)
3rd sort: Driver Name (ascending)

Possible ways this could work:

Shift + click to add additional sort levels
A sorting pane inside the visual
Manual setup of sort priority and direction for each field

Benefits:

Reduces the need for helper measures created only for sorting
Makes models simpler and easier to maintain
Gives users more control over rankings and operational lists
Creates a more intuitive experience for users familiar with SQL, Excel, and other analytics tools

Use cases:

Rankings with tie-breakers
Lists mixing achieved and not achieved targets
Operational prioritization
Financial and commercial classifications
Hierarchical ordering in Matrix visuals

idea Allow multi-column sorting in Table and Matrix visuals in Fabric Ideas

Allow multi-column sorting in Table and Matrix visuals