Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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....
Solved! Go to Solution.
@Anonymous
Just 2 days ago i wrote a quick post on Custom Sorting
Hope it will be useful
http://www.excelnaccess.com/custom-sorting-in-power-bi/
Thanks Zubiar...
got half way their missed the last steps out.....excellent aritcle
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/
@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?
The provided solution is not working if you want to sort the column headers of a matrix.
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.
Hi
How would you create a numeric rank column...happy to learn...i tried adding an index column did not work??
@Anonymous
Just 2 days ago i wrote a quick post on Custom Sorting
Hope it will be useful
http://www.excelnaccess.com/custom-sorting-in-power-bi/
Hello,
For some reason this link is not working. Can you please re-send?
Thanks!
I have a Matrix that I am trying to sort the column headers in.
I would like to put the column headers in this order:
I tried creating a new column and called it Deal Status Column and used the following:
Hi Zubair
Can we un do the acceptance...i clicked the wrong button, your solution was prefect.
Thanks Zubiar...
got half way their missed the last steps out.....excellent aritcle
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |