Sort month in matrix Table

[umairarshad]

Hi all,

I need to sort months in the custom order in matrix table

April

May

June

.

.

.

March

Please help how to do it?

edit:

The Month column is text type.

[danextian · Accepted solution]

Hi @umairarshad ,
Your month ( text string) should be custom sorted by another column else it will be sorted alphabetically. Create a custom sort column depends on your data model. If you have  separate dates table (which is the good practice), you can create a calculated column MONTH(datestable[date]). If you're using a column from your fact table and month name  is just the month name of a date in your fact t able, you can use the same method. If you are using that  month column that is already in  fact table and there are no dates, you need to create a custom column in Power Query say if [month] = "January" then 1 else if  [month] = "February" else 2 ... else 12

[umairarshad · Accepted solution]

Thank you guys. I got it. Selected the month from date Hierarchy and its done. I dont know how but it worked.

Thank you all.

Please close this thread.

[danextian]

That will work because, in the background, it is being sorted by another column. It is good for beginners but you'll eventually learn that it isn't a good practice. 

[danextian · Accepted solution]

Hi @umairarshad ,
Your month ( text string) should be custom sorted by another column else it will be sorted alphabetically. Create a custom sort column depends on your data model. If you have  separate dates table (which is the good practice), you can create a calculated column MONTH(datestable[date]). If you're using a column from your fact table and month name  is just the month name of a date in your fact t able, you can use the same method. If you are using that  month column that is already in  fact table and there are no dates, you need to create a custom column in Power Query say if [month] = "January" then 1 else if  [month] = "February" else 2 ... else 12

[Ritaf1983]

Hi @umairarshad 

Please refer to my solution in the linked discussion.

It includes PBIX with the example and link to the video guide.

https://community.fabric.microsoft.com/t5/Desktop/How-to-get-line-chart-sorted-by-month/m-p/3241078

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