When I use a matrix and make the columns be some period of time (either month, or week, etc..), the column headers show numbers instead of the month name (Jan=1, Feb=2. etc) or week-ending date (shows week #'s 1 thru 52). How can I show the month name or week ending date instead? I used a standard dates table.
For showing month names, drag that specific column to the Column labels section. You can extract the Month name from a date by using this formula
Hope this helps.
You are welcone. If my previous reply helped, please mark it as Answer. Try this
Now see your visual.
I used a standard dates table.
In your dates table, create two calculated columns.
MonthName = 'Dates table'[Date].[Month]
MonthNo = 'Dates table'[Date].[MonthNo]
Then, choose [MonthName] column, change its default sort by column to [MonthNo]. Set its order to Ascending.