Unable to get the columns in order on Matrix table

[Anonymous]

Hi, I was trying to get the week number column headers in order which doesn't happen when I try with a week column(concatenated week + week number) but it works only with the week number as in below picture. what could be the reason. please assist.

Above table it works fine with only week number.

when I try the same with concatenated week field. week 5 and 9 comes towards the end.

[Anonymous · Accepted solution]

Hi @Anonymous,

Nathaniel is right. 
You can sort [week] by [week number].

Sort one column by another column in Power BI

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Nathaniel_C]

Hi @Anonymous ,

The one that works is because it is an integer and it sorts in numeric order, the second column is a text and sorts in alpha order.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel