cancel
Showing results for
Did you mean:
Member

## Showing Month Names in columsn of a Matrix

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.

Thanks,

Steven

8 REPLIES 8
Super User

## Re: Showing Month Names in columsn of a Matrix

Hi,

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

=FORMAT(Calendar[Date],"mmmm")

Hope this helps.

Member

## Re: Showing Month Names in columsn of a Matrix

Thank you! But where is the columns label section?

Super User

## Re: Showing Month Names in columsn of a Matrix

In the visualisation pane, drop the Month name field from the Calendar table in the column section.

Member

## Re: Showing Month Names in columsn of a Matrix

Thank you! OK that worked, but now my months show all out of order? How do I get them in the right order?

Super User

## Re: Showing Month Names in columsn of a Matrix

1. Create a 2 column by 12 rows table.  In the first column, type all month names and in the second one type numbers from 1 to 12 signifying the order of each month.  Tha Table name is Month_order.  the first column is titled as Month and the second one is Order
2. Create a relationship from the Month column of your calendar table to the Month column of the table created in 1 above
3. In the Calendar Table, enter this formula = RELATED(Month_Order[Order])
4. Click on any one cell in the Month column and go to Home > Sort By column > Order

Member

## Re: Showing Month Names in columsn of a Matrix

I'm so sorry to bother you! Where in the calnedar table do I type ' = RELATED(Month_Order[Order])'?

Super User

## Re: Showing Month Names in columsn of a Matrix

Hi,

Highlighted
Community Support Team

## Re: Showing Month Names in columsn of a Matrix

Hi @sshweky,

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.

Result.

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.