Forum Discussion
Can the Column Sequence within a Matrix visual be sorted using the column Total
Hmmm. Interesting. I haven't tested this, but here's what I'm thinking. You know how Power BI default sort is alphabetically, which presents a problem with Month Names, so in our date table we create a sort column. I'm wondering if you can create a calculated column using RANKX to rank your Companies by Total Profit. Then in your company table, sort your company name by the rank column. Then in your visual, sort by Company ASC. Give that a go and let us know if it works.
**edit: on further thought, I don't think an X function will work as a calculated column. You may need to create a calculated table with SUMMARIZECOLUMNS and RANKX as your expression. Use this output as a dimension of your company table. Then use the company name value from this calculated table as your axis value in your visual.
Hello,
I found this post: https://community.fabric.microsoft.com/t5/Desktop/Matrix-Sort-Column/m-p/2189220#M802089
and this one: https://community.fabric.microsoft.com/t5/Desktop/Horizontal-Sorting-of-tables/m-p/353674
I didn't know this, but as of two years ago you can't sore horizontally. They may have fixed this issue, but other than manually moving them, I don't think it can be done. I'll keep looking for more current documenation on this matter and reach out if I find something.
Additionally, I hope I am understanding your problem correctly.
Best of luck,
Cam
