Sorting Matrix so that Months Show in Proper Order

[Anonymous]

Hi team! This is my first question, but I am having trouble sorting my matrix in PowerBI to show months in the correct order. Has anyone else solved this issue?

I need it to be: January, February, March.

What I have tried:

1. Created a field that FORMATS the text field that originally pulled the month name into a 'Date' datatype field that has the [MonthName]. (ie, January, February,...)

[SammieK11]

My Date Table is sorted by Month.1 however the months in Matrix are still not sorting correctly  

[v-zhangti]

Hi, @Anonymous 

You can sort your months by date column.

Select month name to sort by date order. The matrix will then be sorted from January onwards.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[truptis]

Hi @Anonymous , Currently, it is getting sorted Alphabetically. You can click on your visual, see the 3 dots option on the top right, click on Sort Ascending and then select your month. Refer the screenshot below: 

@Anonymous -> If this helps you, then pleas mark it as a solution & hit the thumbs up. Thanks.

[VIJAYKUMART · Accepted solution]

1. add month id column in power query and close and apply

2. do the following sort order 

Hope this helps.