Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
snifer
Post Patron
Post Patron

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

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.

View solution in original post

3 REPLIES 3
Stachu
Community Champion
Community Champion

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



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

@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

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.