cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sandeep3596
Frequent Visitor

Matrix MonthName column showing out of order

 

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.

Screen.pngSort.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Matrix MonthName column showing out of order

You can create a month sort column like

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

And mark it as sort column

Sort_by_column.pngSortnewribbion.png





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


View solution in original post

4 REPLIES 4
Super User IV
Super User IV

Re: Matrix MonthName column showing out of order

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.

---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super User IV
Super User IV

Re: Matrix MonthName column showing out of order

You can create a month sort column like

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

And mark it as sort column

Sort_by_column.pngSortnewribbion.png





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


View solution in original post

Highlighted
Sandeep3596
Frequent Visitor

Re: Matrix MonthName column showing out of order

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 

Microsoft
Microsoft

Re: Matrix MonthName column showing out of order

Hi @Sandeep3596 ,

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

Top Solution Authors
Top Kudoed Authors