Allow multi-column sorting in Table and Matrix visuals

[Gepax]

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