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
PIBFSteve
New Member

Matrix Column Sort

Hi - new to PBI and looking for some guidance on how to sort columns in a matrix. Pulling back data from sql server for retirees. I extract the year, month and month index from a datetime where month is the name. After creating the matrix i have the rows as year then retirement type and month as the column but April is coming first which makes sense. Problem I'm having is when I highlight the month index column and click modeling tab and sort by month index PBI desktop looks like it's re-sorting but data stays the same with April first. Any ideas how to gete around this?

 

Many Thanks!

1 ACCEPTED SOLUTION
PIBFSteve
New Member

I was able to figure this out. I needed to highligh the actual Month Name, then click sort by Month Index then it sorted as I needed it to.

View solution in original post

2 REPLIES 2
PIBFSteve
New Member

I was able to figure this out. I needed to highligh the actual Month Name, then click sort by Month Index then it sorted as I needed it to.

Hi, @PIBFSteve 

It seems that you have find the solution.

If so, please accept you reply as solution to close this thread, so that other community members will easily find the solution when they get the same issue.

 

Best Regards,
Community Support Team _ Eason

 

 

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.