Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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!
Solved! Go to Solution.
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.
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
User | Count |
---|---|
141 | |
70 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |