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

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

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.

  • Tony_pim's avatar
    Tony_pim
    New Member
    5 years ago

    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