How to change Month Abbreviation in Table Matrix

[aishak12]

Hi All, 

I have a calculated column to convert my Period column into dates. Now in the table matrix it shows the months as (January, February, March). Is it possible to convert these into abbreviations such as (JAN, FEB, MARCH)?

[PhilipTreacy]

Hi @aishak12 

Select the column and then in the Ribbon type in the Format String mmm and press Enter

Regards

Phil

[aishak12]

Im sorry im also using the format for year, How would I change it for this situation

[PhilipTreacy]

Hi @aishak12 

So you want to show the year and month in the Matrix?

OK, instead of just typing mmm into the Format area type mmm yyyy which will give you (for example) Jan 2021 .

Applying formatting like this is better than changing the underlying data type to string (text) in your column.  Leaving the column as DateTime allows you to still use it in other calculations that require a date.

regards

Phil

[Anonymous]

HI @aishak12 

You can use

PeriodFormatted = FORMAT(DATE(LEFT([Period],4), RIGHT([Period],2),1), "yyyy-mmm-dd")

Also, if you need any other formatting help refer to the below link.

FORMAT function (DAX) - DAX | Microsoft Docs