Forum Discussion
Sort Column Header in Matrix Table
Hi Experts
I am trying to sort column Headers in a Matrix Table.....so they are in number order increasing...unable to do this action???
The image shows 1 then 10 then 11 and not item 2 then 3 etc....
Anonymous
Just 2 days ago i wrote a quick post on Custom Sorting
Hope it will be useful
10 Replies
as the field type is text it sorts alphabetically
you can either:1) use custom sort (you would need to create numeric rank column first)
2) reformat the data so alphabetical order would meet your needs, e.g. changing format number to 01, 02, ... , 10, 11 etc.
Anonymous
Just 2 days ago i wrote a quick post on Custom Sorting
Hope it will be useful
The provided solution is not working if you want to sort the column headers of a matrix.
Zubair_Muhammad Stachu Hi, your solutions work assuming that you are in Import mode and see the Table view. Any solution for users using Direct Query to order the column headers in a specific way other than alphabetically?
Thanks for sharing… check out the links below. It provides a comprehensive guide on how to sort measures as columns
in a matrix visual.
https://insurancedatainsights.blog/2024/04/27/dax-topn-brokers-and-others/
