DAX Table Sorting Months

Hi jmfillman,

Just checking, have you had a chance to open a support ticket, as suggested. If so, we'd love to hear the current status or any updates from that.

Regards,

Prasanna Kumar

Hi jmfillman,

Just following up to see if the solutions provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

Hi jmfillman ,

it is working. i just take your date table script and sort the date field by the sort column option and i can make the month in order. please follow the below options,

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

I am not able to upload a PBIX file for some reason. Hoping images showing the setup of the matrix (columns only so far) will help.

I added a numeric Month column to the table. Filtering on the month column (or any column) makes no difference to what is diplaying on the matrix.

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.

hi jmfillman , Please create a sort column in your table and then use sort by column and use the new column "MonthSort =
SWITCH(
[MonthName],
"Jan", 1,
"Feb", 2,
"Mar", 3,
"Apr", 4,
"May", 5,
"Jun", 6,
"Jul", 7,
"Aug", 8,
"Sep", 9,
"Oct", 10,
"Nov", 11,
"Dec", 12,
BLANK()
)"

Hi jmfillman,

If the issue still persists, we kindly request you to share the sample data in a workable format such as text, an Excel file, or a PBIX file with sample data instead of screenshots. Additionally, please include the expected output. This will enable us to assist you more effectively.

Thanks & Regards,

Prasanna Kumar

I appreciate the responses. Setting the sort column in the data view has no impact on the order in the Matrix. The sort in the below image is correct...

but the Matrix continues to show the months in alphabetical order