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

[Anonymous]

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!

[Greg_Deckler]

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

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

[Anonymous]

Really appreciated this one!

[Anonymous]

Hi @Anonymous,

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

FORMAT(TableName[Date], "MMM")

Regards,

L.Meijdam

[Anonymous]

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?

[Greg_Deckler · 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.

[pthornton]

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