Forum Discussion
Helper ISorting decimal number in matrix fails
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,
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
4 Replies
- amitchandak
Super User
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,
v-yalanwu-msftCommunity Support
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.- 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.
