convert datetime field to MMM-YYYY format not showing correctly in visuals

[ryanb11]

I want to convert a datetime field into MMM-YYYY format, which looks to work when using:

YearMonth = FORMAT('Journey'[Completion-Time], "MMM-YYYY")

But when applying the YearMonth column to visuals on a chart the axis shows the datetime values, even though in the query editor the dates look to be in MMM-YYYY format.

How can I correct this so the charts show the YearMonth in "MMM-YYYY" and not datetime format.

In the query editor for Completion-Time I have tried selecting the data type as text, date, datetime but still the same issue.

Sample data below 

Completion-Time	YearMonth
15/07/2020 15:16:16	July 2020
20/08/2020 17:16:08	August 2020

[Anonymous]

Hi @ryanb11 ,

According to my understanding, you want to format datetime with “Month-Year” , right?

For my test,once Format() is used, the type of the data will become String,  so just make sure the data type is Text like this:

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[amitchandak]

@ryanb11 ,

I doubt this column can come has date-time, unless data type is changed.

YearMonth = FORMAT('Journey'[Completion-Time], "MMM-YYYY")

Sorting can be an issue , you can sort on the column

YearMonth Sort= FORMAT('Journey'[Completion-Time], "YYYYMM")

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Anonymous]

Create a new calculated column in report view and use the following formula:

MMMYY = FORMAT([Date],"MMM-YY")

Ensure you switch out "Date" for the name of your Date column. 

[ryanb11]

I tried that but it didnt work, the dates in the visual are still showing as datetime

any other ideas? @Anonymous 

[Anonymous]

HI @ryanb11 

Consider converting the column to date before using the below formula.

FORMAT(table[date],"MMM-YYYY")