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
Anonymous
Not applicable

Sort Date Hierarchy

How do you sort the month in a date hiearchy?

I have a month abbreviation sort column. My table is sorted by DateKey. 

 

It would be nice to set MonthAbbr sort by MonthNumberOfYear just like I would in SSAS. 

I don't want to mess up my DateKey Sort as the default on the table. 

 

sort01.JPG

 

sort02.JPG

 

sort03.JPG

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I found the answer. In the modeling, click the column and use the Sort By Column button and select the sorting columns. 

 

sort06.JPG

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

I also want to be able to do this:

sort04.JPG

Months by Year. 

Anonymous
Not applicable

Is there a way to have 2 hierarchies sort in different ways. 

 

sort05.JPG

Anonymous
Not applicable

I found the answer. In the modeling, click the column and use the Sort By Column button and select the sorting columns. 

 

sort06.JPG

Smiley Happy

 

Best Regards
Maggie

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.