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


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

6 REPLIES 6
Greg_Deckler
Super User
Super User

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

 

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

@ 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!:
Mastering Power BI 2nd Edition

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.


@ 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!:
Mastering Power BI 2nd Edition

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