topic Re: How to get format of Month "MMM-YY" in matrix view in DAX Commands and Tips

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

Anonymous — Mon, 02 Aug 2021 09:26:45 GMT

Hi Team

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

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 -

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

Kindly suggest

Thanks and regards

RatanB

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

Samarth_18 — Mon, 02 Aug 2021 11:16:02 GMT

Hi Anonymous

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

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

Fowmy — Mon, 02 Aug 2021 13:22:52 GMT

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

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

Anonymous — Tue, 03 Aug 2021 12:43:49 GMT

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

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

Samarth_18 — Tue, 03 Aug 2021 13:09:25 GMT

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