Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
HenryJS
Post Prodigy
Post Prodigy

Matrix Month Column Wrong Order

Hi all,

 

I have placed the month name column (below) in a matrix however it does not order correctly.

 

 Month = MONTH([Date])

 

Month Name = SWITCH('Calendar'[Month],1,"January",2,"February",3,"March",4,"April",5,"May",6,"June",7,"July",8,"August",9,"September",10,"October",11,"November",12,"December")

 

How can I order the Month Name from January to December?

 

Capture.PNG

1 ACCEPTED SOLUTION
jbirco
Resolver I
Resolver I

in the data view click on the month name column and thenunder the column tools tab click the sort bycolumn tab to sort by the month number column 

View solution in original post

7 REPLIES 7
borensm
Regular Visitor

Actually, I figured out how but I'm getting this error message:  

borensm_0-1695663744059.png

 

it should be just the month number not the monthyear 

Thank you that worked!

jbirco
Resolver I
Resolver I

in the data view click on the month name column and thenunder the column tools tab click the sort bycolumn tab to sort by the month number column 

camargos88
Community Champion
Community Champion

@HenryJS ,

 

You can create a column on the date table like:

YearMonth = FORMAT(TABLE[DATE], "YYYYMM")

 

MonthName = FORMAT(TABLE[DATE], "MMMM")

 

and sort the MonthName by YearMonth



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



I followed you until the last step.  How do I sort MonthName by YearMonth in a matrix table?

 

once you do the sort in the table view it will work in all visuals including the matrix, BTW you can sort it by a column that has just the month number it dosn't have to be a yearmonth column

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.