cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChrisEby Frequent Visitor
Frequent Visitor

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

Accepted Solutions
Super User
Super User

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

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


5 REPLIES 5
LMeijdam Established Member
Established Member

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

Hi @ChrisEby,

 

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

FORMAT(TableName[Date], "MMM")

 

Regards,

L.Meijdam

Super User
Super User

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

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

 

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


ChrisEby Frequent Visitor
Frequent Visitor

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

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?

Super User
Super User

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

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
pthornton Frequent Visitor
Frequent Visitor

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

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