Forum Discussion
Sorting by Month in Matrix Table
Sorry, I may be misunderstanding what you have done, but...
The date table should be sorted by the date column.
To sort the Month Name column, you need to select it and then use the "Sort column by..." and choose the month number as the sorting column.
They are two seperate "sorting" operationsIf you have a measure, you can create a new measure using SWITCH to create the order measure and use that as as the sorting criteria
Hi Paul,
I have same requirement. But the column from where I am getting date is a Measure and this measure is of text type.
Used dax to extract year , month, quarter etc.
The months are getting displayed in alphabetical order but I want it in calendar months.
If you have a measure, you can create a new measure using SWITCH to create the order measure and use that as as the sorting criteria