cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
snifer Member
Member

month full exstension in matrix

 Capture.PNGCapture1.PNGi 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?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: month full exstension in matrix

Hi @snifer,

 

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

sort by column.png

 

 

Here is my test output.

 

Capture.PNG

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Highlighted
Super User
Super User

Re: month full exstension in matrix

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 Member
Member

Re: month full exstension in matrix

@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

 

Capture.PNG

Community Support Team
Community Support Team

Re: month full exstension in matrix

Hi @snifer,

 

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

sort by column.png

 

 

Here is my test output.

 

Capture.PNG

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.