Matrix MonthName column showing out of order

[Anonymous]

I have a date dimension table sorted based on the unique date field and even then I am running into below MonthName Year showing out of order.

Any help is greatly appreciated to fix these column orders.

[amitchandak · Accepted solution]

You can create a month sort column like

Moth year sort = format([Date],"YYYYMM")

And mark it as sort column

[Anonymous]

Looks like the mistake I have done was, I am applying the sorting by Date on a Column which is not being used in Report.

After Applying the sort for MMM YYYY column based on Date filed the issue was fixed.

Thank you @amitchandak @Greg_Deckler 

[v-yiruan-msft]

Hi @Anonymous ,

Is there anything else need help about this thread? If no, could you please mark the helpful post as Answered? It will help other member in the community find it easily if they face the similar problem with you. Thank you.

Best Regards

Rena

[Greg_Deckler]

You typically need to create a MonthSort column like MonthSort = MONTH([Date]) and then you set the Sort By for you column to sort by MonthSort.