Forum Discussion
Solved
DAX Table Sorting Months
I am creating a date table with the below, but whenever I drop this into a Matrix displaying columns of Fiscal Year, Quarter, and Month, the Months are in alphabetic order by quarter instead of month...
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
I would like to add a PBIX files here, but Fabric doesn't seem to allow it, so sharing a link to a sample PBIX file: Matrix Calendar Display
Adding a numeric month value and setting that as the sort column had no impact on the month order displayed in the matrix. The table view sorts as expected, but that has no impact on the matrix month order of display.