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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

How can I specify use of 3 character month abbreviations (Jan, Feb, Mar...) in date hierarchy?

Using a date in the axis of a cluster column chart visualization and want the axis labels to use the 3 character month abbreviations rather than the full month name "Jan, Feb, Mar, etc." rather than "January, February, March. etc." when drilling to that level of the hierarchy.

 

Do not see any 'out of the box' formatting cards for this and wondering if there's another way to accomplish this.

 

Any help would be greatly appreciated!

1 ACCEPTED SOLUTION

You would likely have to create your own hierarchy which means that you would have to create columns for each of the values created with the auto data hierarchy and then build a custom hierarchy off of those columns.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

6 REPLIES 6
Greg_Deckler
Community Champion
Community Champion

You can create a calculated column in your data model using a DAX formula of:

 

3LetterMonth = FORMAT([Date],"MMM")


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Really appreciated this one!

Anonymous
Not applicable

Hi @Anonymous,

 

You can use the following code to format to 3 char month abbreviations:

FORMAT(TableName[Date], "MMM")

 

Regards,

L.Meijdam

Anonymous
Not applicable

I am familiar with creating an additional column using that syntax, but how do I embed that into the hierarchy of the date being used in the axis of a clustered column chart?

You would likely have to create your own hierarchy which means that you would have to create columns for each of the values created with the auto data hierarchy and then build a custom hierarchy off of those columns.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Power BI loves to make the simplest things more difficult than they need to be

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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