cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sshweky Member
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
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.

sshweky Member
Member

Re: Showing Month Names in columsn of a Matrix

Thank you! But where is the columns label section? 

Super User
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.

sshweky Member
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?

Highlighted
Super User
Super User

Re: Showing Month Names in columsn of a Matrix

You are welcone.  If my previous reply helped, please mark it as Answer.  Try this

 

  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

 

Now see your visual.

sshweky Member
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
Super User

Re: Showing Month Names in columsn of a Matrix

Hi,

 

Share the link from where i can download your file.

Community Support Team
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]

1.PNG

 

Then, choose [MonthName] column, change its default sort by column to [MonthNo]. Set its order to Ascending.

2.PNG

 

Result.

3.PNG

 

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.