Showing Month Names in columsn of a Matrix

[sshweky]

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

[v-yulgu-msft]

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

[Ashish_Mathur]

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]

Thank you! But where is the columns label section? 

[Ashish_Mathur]

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

[sshweky]

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

[Ashish_Mathur]

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]

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

[Ashish_Mathur]

Hi,

Share the link from where i can download your file.