3 character month abbreviations in hierarchy with “Concatenate labels” function off, grouped by year

[XeniaBarmotska]

Hi PowerBI experts, 

it is possible to turn off the “Concatenate labels” function, in such a case a diagram looks like this:

I need the same, but only with 3 character month abbreviations. This is not a standart hierarchy then and it's sorted then by moths, because there is, for example,  Mai in 2018,2019 and 2020, and I cannot use the sort by column function. Maybe it's possible to realize it somehow? And when I turn off  “Concatenate labels” function using my own hierarchy, it doesn’t effected the Diagram.  Please help!

[amitchandak]

@XeniaBarmotska , if you are using date hierarchy, you can use the drill down or remove year in the field list.

If using the date table you can month there and use that as row

new column

 month = format([Date],"MMM")

[dedelman_clng]

Hi @XeniaBarmotska -

On your Date table, make a new column

MonthShortName = FORMAT(DateTab[Date], "MMM")

Then select the column in your "Fields" pane, and go to Column Tools -> Sort by Column and choose the field with the Month Number (1 = Jan, 2 = Feb, etc).  You can also do the Sort by Column with the existing long month name.

Hope this helps

David

[XeniaBarmotska]

it doesn’t sort right in such a case. And "Concatenate labels” function off, still doesen't work.

[dedelman_clng]

@XeniaBarmotska check the sorting option under the 3 dots in the top right corner and make sure it is sorted by something related to the date.  Looks like it might currently be sorted by the value, not the axis.

[Anonymous]

Hi @XeniaBarmotska 

Create a new column like

CONCATENATE(YEAR([Date]),MONTHT([Date]))  // you sure will have different years too to dispaly in the same chart.

Or

YEAR([Date]) & MONTHT([Date])

and use it to sort.

[XeniaBarmotska · Accepted solution]

Yes, this way I can sort them well, but I can't use the "Anti-TY Tags Concatenation" feature, I want to show a year for the whole month within this year then see the image in my question

[XeniaBarmotska]

Exactly, what I wanted, and the solution was so easy! Thanks a lot.
PS.: only the month are sorted alphabetically, but I know how to handle this

[XeniaBarmotska]

now it's completely correct

[dedelman_clng]

@XeniaBarmotska - create a MonthNumber column

MonthNumber = MONTH( Table[Date] )

The use that to sort.

Also, be aware that best practices will have you create a separate Date table if you want to do any Time Intelligence functions (TOTALYTD, etc).

Hope this helps

David