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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
chillpill
Helper I
Helper I

Maintaining sort order with Top N under a Matrix

How do you keep the Months properly sorted in order (from Jan-Dec) but also show the top # from top to bottom in the Count? In Excel it's easy but in PBI I am having trouble finding a solution.

 

Capture.JPG

2 REPLIES 2
amitchandak
Super User
Super User

@chillpill , You need to have a sort column for month

 

Month = FORMAT([Date],"mmmm")
Month sort = month([DAte])

 

mark month sort as sort column for month

 

Sort Month.png

 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Not sure I follow because I already sort the Month column by Month Number (as you describe above), but the items underneath the Month in the Matrix I am unable to sort in Descending order while maintaining the correct order of the Months..

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors