Forum Discussion
DAX Table Sorting Months
- Anonymous1 year ago
Hi jmfillman,
If the issue still persists, I’d recommend raising a support ticket with Microsoft. The support team can look into the backend and provide more in-depth assistance tailored to your environment.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticketThanks & Regards,
Prasanna Kumar
HI Azadsingh, techies , and FreemanZ
I copied in updated formula suggestions and set the sort to the various columns suggestions, but does change to the month sorting. For the purposes of demonstration, I added the FiscalMonthNumber to the matrix. Sorting on this column, like any of the others, does not change the sort order in the matrix. You can see this in the PBIX file I linked to in a previous post here: Calendar Matrix
This information provided here: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column seems to only apply to gaph visuals, not the matrix visual. Following the first set of steps, to set the Sort Column, as noted here and previously, does not change the sort order of my matrix. Maybe a bug in the July BI Desktop release??
If I remove the Fiscal Month column and just keep the month number, the numeric month order is correct, but choosing the sort column has no impact on how the matrix is sorting, it is always going in a-z/1-9 order depending on the data type, no matter what sort column is selected.
To confirm, I need to display like the below:
2025 2026
Q4 Q1 Q2 Q3
Apr May Jun July Aug Sep Oct Nov Dec Jan Feb Mar