Forum Discussion

mrbartuss's avatar
mrbartuss
Advocate II
1 year ago

Sorting Matrix Columns by Measure Total

Is it possible to sort columns in a Power BI matrix visual by the total in descending/ascending order? I've noticed this option is available for rows, but not for columns.   I attempted to create a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi mrbartuss ,

Thank you for reaching out to the Microsoft Fabric Community.

 

Power BI currently does not support dynamic sorting of matrix columns by measure totals. Sorting is only available for rows, not columns.

The workaround involving individual measures works in static scenarios, but as you've noted, it's not dynamic and doesn’t respond to slicers or filter changes.

As an alternative, consider:

  • Swapping columns to rows, where dynamic sorting is supported.

  • Exploring custom visuals from AppSource that offer column-sorting capabilities.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

 

Thankyou.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi mrbartuss  ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.


Thank you.