Hi everyone!
I've created a matrix with several numbers, and I've set it to get a descendeing order. But it isn't ordering correctly as you can see in the picture:
Do you have any idea of how can I fix it ?
I have tried to change the ordering parameter, and it only works right with an alphabetical order... but it's not the order that I need.
Thanks!
@Tony_pim you can't sort matrix visual, if you have anything on the column, in your case Year is on the column if you remove that, you will be able to sort it by what measure you have on the values.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @Tony_pim
Which value field do you hope to sort by? Check whether it is of numeric data type (whole number or decimal number). Maybe it looks like returning a number but actually of text data type?
If there is only one value displaying in the column, all value fields could be sorted by.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Hello!
I've tried that before post my problem, and it doesn't work. The print in the main post is after ordering it exactly as you say. If I don't order it, the positions get order by name, or doesn't get order at all.
I need to order it by TC Part or Prima Directa.
Nice try!
Thanks
@Tony_pim you can't sort matrix visual, if you have anything on the column, in your case Year is on the column if you remove that, you will be able to sort it by what measure you have on the values.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Tony_pim right now seems like it is ordered on another column, what do you have on rows/columns/values on the matrix?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
In the header of the column I have a year, where that percentage and the amount, are part of a same year. In the header of each row I have a company.
there is an example.
So, there's no more columns to be ordered, I've tried with both numbers, and it doesn't get ordered correctly.
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
FabCon &SQLCon Highlights
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
