Sorting decimal number in matrix fails

[mphillenga]

Hello,

I have a report displaying a matrix containing several text fields in rows and several measures as values.

One of the columns contains a start week which looks like e.g. '202115' and is formatted as decimal number.

I would like to sort the start week. But it always shows up in the wrong order as shown below:

 

I checked all DAX code as shown below:

And also the sorting on column was set: 

Anyone any idea what the issue could be?

Thanks,

[v-yalanwu-msft]

Hi， @mphillenga ；

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @mphillenga ;

Please try clicking on this column in the matrix once or twice.

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@mphillenga , this is a sortable number. I doubt you need sort column. Can remove sort column for start week and try again

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[mphillenga]

Hi,

Thanks for the suggestion. It did not solve my problem.

However I manage to find it. If I use a table instead of a matrix the sorting works fine.

Thanks,