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
Anonymous
Not applicable

How to get format of Month "MMM-YY" in matrix view

Hi Team

 

Below is the screenshot of my table in which Months are showing in columns.

RatanBhushan_0-1627896449397.png

 

I would like month to be seen as "mmm-yy". I have been able to make new column for data using "

New Month = FORMAT(AllKpis[Month],"MMM-YY")" but this column is sorted as below -
RatanBhushan_1-1627896507052.png

 

Is there a way to sort this as Jan-21,Feb-21 and so on?

 

Kindly suggest

 

Thanks and regards

RatanB

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@Anonymous 

You should add a column with "Mmm YYYY" then another column with SortColumn = INT ( FORMAT (Table[DAte],"YYMM") ) then sort by this:

Wat this video for instructions: https://www.youtube.com/watch?v=NlX7Cp2P0d4



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

4 REPLIES 4
Fowmy
Super User
Super User

@Anonymous 

You should add a column with "Mmm YYYY" then another column with SortColumn = INT ( FORMAT (Table[DAte],"YYMM") ) then sort by this:

Wat this video for instructions: https://www.youtube.com/watch?v=NlX7Cp2P0d4



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Samarth_18
Community Champion
Community Champion

Hi @Anonymous 

 

Have you try to convert date format from ribbon because in that case seperately sorting is not required.

 

Samarth_18_1-1627902915981.png

 

 

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

Anonymous
Not applicable

this format is not coming in my power bi? How to get this?

@Anonymous you can directly write this "mmm-yy" over there.

Samarth_18_0-1627996143379.png

 

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

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.

Top Solution Authors