Forum Discussion
Sort column in a matrix PBI
Hello,
I'm having problems with sorting: when I do a normal sort it orders the rows, but if I wanted to sort not only by rows but also by columns, how can I do that? For example, in the picture below I would like to sort the column too by value.
Thank you in advance.
7 Replies
Power BI does not support dynamic bucketing or column sorting. You would need to fake it by having a pre-sorted reference table (as simple as GENERATESERIES(1,10) ) and then use a measure that would calculate the RANK of each cell and column total.
If you want the column names sorted by the totals values then that can only be precomputed in a calculated table, it cannot be done dynamically.
Hi Domenico96
The column headers in matrix can be sorted alphabetically in ascending order or through a custom column sort - either of these of cannot be changed directly from the visual.
Note: Create the custom sort column in Power Query. If the sort column is created in DAX and uses the letters column as a reference, and the letters column is then set to sort by that DAX column, it creates a circular reference because each column is referencing the other which is not allowed.
Hi,
One of the ways is using one additional 'Sort table'.
Suppose there's a simple table1 that looks like
then create a 'Sort table' with DAX and Sort the Region Column by Sales.
In reporting, use 'Region' from 'Sort table'
Unfortunately I tried with all of the suggestions, and MasonMA 's looks the best so far, but unfortunately when I use filters the order is not working correctly. Do you have any other idea ?
Hi Domenico96 ,
Thank you for the update.
In Power BI Matrix you can sort rows by a measure, but you cannot sort columns by values in the same way. This is a limitation of the Matrix visual, Rows can be sorted dynamically but columns cannot be sorted dynamically based on a measure.
We would recommend submitting your detailed feedback and ideas through Microsoft's official feedback channels, such as Microsoft Fabric Ideas. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.
https://ideas.fabric.microsoft.com/ideas/search-ideas/
Thank you for being a valued member in Microsoft Fabric Community Forum
Regards,Dinesh
Hi Domenico96 ,
We haven’t heard from you on the last response and was just checking back to see , Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback. Thank you for being part of the Microsoft Fabric Community.
Regards,
Dinesh
Hi Domenico96 ,
Thank you for reaching out to the Microsoft Community Forum.
Hi MasonMA , lbendlin and danextian Thank you for your prompt responses.
could you please try the proposed solutions shared by MasonMA , lbendlin and danextian ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.
Regards,
Dinesh
