Date Hierarchy Format in Column Chart

Question

I am currently using Date Hierarchy, and the format for YEAR & MONTH is "2017 January, 2017 February........2018 December"

Is there any way to truncate this format to "2017 Jan, 2017 Feb" OR "Jan 17, Feb 17....Dec 18"

I need the Date Hierarchy function to DRILL UP & DOWN, but i cant seem to change the format.

Kindly Advise.

Thanks!

Drip UPDrill DOWN

phil_seamark · Answer

Hi there,&nbsp;You can use the FORMAT fuction in DAX to create new columns in your date/calendar table.&nbsp;Perhaps use the following code to create a new calculated column&nbsp;Year and Month = FORMAT([date col], "YYYY MMM") &nbsp;&nbsp;

anonymous · Answer

Hi hackfifi,
&nbsp;
For your requirement, you can add the calculate column with specific format, then create hierarchy column with these formatted columns.
&nbsp;
Sample:
Table = ADDCOLUMNS(CALENDAR(DATE(2015,1,1),TODAY()),"Year",FORMAT([Date],"YYYY"),"Month",FORMAT([Date],"MMMM"),"Day",FORMAT([Date],"D"),"Year Month",FORMAT([Date],"YYYY MMM"),"Month Day",FORMAT([Date],"MMM d"))
&nbsp;

&nbsp;
Regards,
Xiaoxin Sheng

hackfifi · Answer

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks Phil_Seamark&nbsp;- Please see update above. I seem to have lost the capability to Drill up &amp; Down - also, the dates do not seem to be sorted in order..."2017 Apr, 2017 Aug, 2017 Dec....2018 Sep"&nbsp;

hackfifi · Answer

&nbsp;Thanks Anonymous&nbsp;-To implement your solution&nbsp;I followed the below steps:1. Create Table "Calendar" as per your formula2. Create Relationship: Linked "Date" [Table: Calendar"] &amp; "Period [Table: Summary - Cashflow"3. Used fields "Year", "Year Month", "Month Day" in shared axis [replaced "Period"]4. Screenshot after implementation as above.After implementing your solution, please see above impact while DRILLING DOWN. Also, my Cumulative Calculations are incorrect now.I have attached a screen shot in my initial post of what the chart looks like while using "Period" in the Share Axis Field.Kindly advise if i have done any steps incorrectly.Thanks&nbsp;&nbsp;&nbsp;