Forum Discussion

Tony_pim's avatar
Tony_pim
New Member
5 years ago
Solved

Matrix ordering issue

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...
Need Help
Tips and Tricks
Tutorial Requests
  • parry2k's avatar
    parry2k
    5 years ago

    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.⚡

parry2k's avatar
parry2k
Super User
5 years ago

Tony_pim right now seems like it is ordered on another column, what do you have on rows/columns/values on the matrix?

Tony_pim's avatar
Tony_pim
New Member
5 years ago

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.