Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |