Formatting custom date hierachy

[SamWhitehouse]

Hi All,

I am using a matrix to display the total hours worked per day by resource. 

For the columns, i have a date field and have used 4 custom fields that extract the Week, Month, Year and Day from the "Date" field and then have put them into a hieracyy.

Everything all works (As shown above), however, what i want to do is change the month from a number to text (IE 1 is January). Everytime i have tried it messes up the order of the month. 

Any ideas?

[adambhappy]

In your date table you should have two columns, one that represents the month in text and one that represents the number of the month.

Once this is in place you select the text column of the month, in the ribbon there is a "Sort by column"-button from which you can select the month number. When this is done the month names will be sorted according to the number.

[MFelix · Accepted solution]

Hi @SamWhitehouse ,

Based on the description you have made I assume you have a month number and a month name on your table make the sorting of month name by the month number column:

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-butto...

Regards,

MFelix

[SamWhitehouse]

Thankyou for the response! that worked!