How to change the date format in chart without creating new column in model?

[OneWithQuestion]

I have a line chart and my X axis is calendar date.  I would like to display it a MonthName, Day, Year instead of the current YYYY-MM-DD.

I could make a new calculated column in the model and deploy, but is there a way to just change that field?  I toyed with a quick measure but this is a column not a measure so at best I would need to add a calculated column?

Is there no way to just select a field and change the date format when charting and graphing?

Thanks!

[SivaMani]

@OneWithQuestion,

You can change the format,

[OneWithQuestion]

Ah, ok that does not work in my case.

It appears to be due to it being a live connection to remote data vs locally sourced data (it is SQL Server SSAS Tabular model).

Any other options or does that only work on data that is local to PBI desktop?

Thanks!

[SivaMani · Accepted solution]

@OneWithQuestion,

We have some limitation if we use the live connection (SQL Server Analysis Services) i.e., we can't make data modeling. So we cannot change the date format in Power BI desktop as of now.

You may try it in backend side.

[SivaMani]

@OneWithQuestion,

You can change the format,

[Greg_Deckler]

Go to the Model tab and change the Format.