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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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