Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sshweky
Helper III
Helper III

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
v-yulgu-msft
Employee
Employee

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

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Thank you! But where is the columns label section? 

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

Hi,

 

Share the link from where i can download your file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.