Have to show first 3 letters of months in hierarchy

[Anonymous]

Hello Folks,

I have to show first 3 letters of every months in graphs

Have created separate columns but when I add in hierarchy month order  is not coming correct like for 2020 and 2021 jan showing at first 2020 jan then 2021 jan then 2020 feb, 2021 feb like this 

but have to show 2020 Jan, 2020 Feb.........2021 Jan,2021 Feb like this.

below is system defined hierarchy.

Need help please 

[V-pazhen-msft · Accepted solution]

@Anonymous 

You may create following column to replace the original date hierarchy: 

Column = CONCATENATE([Date].[Year],CONCATENATE(" ", LEFT([Date].[Month],3)))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[WillDrotar]

No way this is an acceptable answer, that just turns it into a text string that doesn't sort by date anymore. In the visual above they had to have manually sorted by descending, and then stopped at February. 

[Adhavan]

Hi,

I used the Calcualted Column and it showing the expected Month Format, but I couldn't achieve the X-Axis format as shown in the image.

Do we have any option to achieve the X-Axis

Thanks in Advance,

Mani

[edhans]

You need to add another column to your date table that is in this format:

MonthName	SortCode
Jan 2020	202001
Feb 2020	202002
Mar 2020	202003
Jan 2021	202101
Feb 2021	202102

Etc. I've left off a lot of data obviously. The following formula as a Custom Column in Power Query will do this:

Date.Year([Date]) * 100 + Date.Month([Date])

I have a date table here with this kind of info - Creating a Dynamic Date Table in Power Query

You then sort the MonthName column by the SortCode above. This article has more details on that procedure.