month full exstension in matrix

[snifer]

 i in my matrix the month are displayed  from number 1 to 11 January -November

i dont find the way to display instead 1-11

January -November how i can do?

[Stachu]

for something like this the texts January-November actually have to be in some column
if you don't have one you can create a calculated one based on existing Month e.g.

MonthName = FORMAT(Date(2020,Table[Month],1),"MMMM")

you just need to replace the blue text to match your naming convention

[snifer]

@Stachu

it worked but problem is that if i use now the measure the month are not displayed in the correct order in the matrix check screenshot

how i can fix that displaying from January Decemberember and not alphabatically

[v-piga-msft · Accepted solution]

Hi @snifer,

You could use Sort by column to achieve your desired output.

Here is my test output.

Best Regards,

Cherry