Changing Month Number to Name - FORMAT not working

[RyanS32229]

I'm trying to plot 2017 figures vs 2018's by month. This is working fine for Month Number on the X axis, using a calculated column simply as MONTH([Date]).

However I really want to see month name along the X axis. I tried using FORMAT(MONTH([Date]), "mmm") however it gives me this:

Seems to be converting the month number into 31st December 1899, 1st Jan 1900, 2nd Jan 1900 etc.

How can I get month names on the x axis?

[ingdanielrayez]

I have the same problem. Could you solve it?

[v-yulgu-msft · Accepted solution]

Hi @RyanS32229,

Two ways to extract month name from a date field:

MonthName = 'Table Name'[Date].[Month]

Alternatively

MonthName = FORMAT('Table Name'[Date],"MMM")

Best regards,

Yuliana Gu

[Floriankx]

Hello I think your formula works fine.

You should sort MonthName by MonthNumber:

Please give it a try and let us know.

Best regards

[RyanS32229]

See the 2nd pic, it's clearly not working.

Using the FORMAT is taking MONTH([Date]) as a Day Number rather than a Month Number, therefore it's formatting January i.e. (01) into 31st December 1899, February into 1st January 1900, March into 2nd January 1900 etc.

[shebr]

Hi @RyanS32229

Can you perhaps share your data set? It could be that your dates are in the wrong format, or the setting in Power BI is set to a different date format also.

If you can send a link to your pbix I can have a look.

Thanks

shebr