how to convert month name to number in matrix

[pardeepd84]

Hi,

I am trying to create a matrix to show the months and cost however the month is being sorted in alphabetical order rather than in chronologica order.  I need it to show as Jan, Feb, March etc however it is being sorted as April, August, December.

Please could I have some assistance with this. 

Thank you

[pardeepd84]

I have tried this but get the following error message:

[v-xiaotang · Accepted solution]

Hi @pardeepd84 

Are these two columns both calculated columns? you can duplicate one column and use that column to sort Month column. or add Index column, and use it to sort Month column.

in my test, I use Date column to sort Month column, it works fine.

Best Regards,

Community Support Team _Tang

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

[Pmorg73]

Is your date table a Dax built table or did you do it in power Query? In fact do you have a seperate date table? This is a highly recommended thin to do.

Cicular dependancy means you are using something that is relying on your current measures. 

Do you have the column I mentioned for sorting? ie a column that returns the month number in your table? Can you screen grab your date table?

[Ashish_Mathur]

Hi,

Please read this article - Sort one column by another column in Power BI Desktop.

[pardeepd84]

I have tried this by when I create a matrix I get this:

[Pmorg73]

I think I know what it is. you need a column for sort order that you want.

So I have a column called sort and I start the month number from where I want it. So fiscal year I make April

'Month FY Sort = if('01_Calendar'[MonthOfCyear]>=4,'01_Calendar'[MonthOfCyear]-3, '01_Calendar'[MonthOfCyear]+9)"

Then highlight your onth number column and click the Sort by button. You need to change that to the new sort number column

[Pmorg73]

Do you have a date table?

Mine is a DAX one. If so make a new column

Month no = FORMAT('Date table'[date], "M")