Date format keeps changing in Power BI desktop

[Anonymous]

Hi,

I have loaded a couple of CSV files into Power Bi. Whenever there is a column related to the date, the format keeps changing automatically. 

The format in Power Editor is mm/dd/yyyy

and the format in Power BI is dddd /mmmm d/yyyy(Wednesday, March 14, 2001).

The issue is that every time I have to manually change the column format in every file which is time-consuming.

As you can see below: I usually change manually either going to Column tools in Data View or Property pane in Model View (image inserted).

date format

Looking for any other best option to solve this issue permanently.

Thanks.

[v-jingzhang · Accepted solution]

Hi @Anonymous 

The default date format in Power Query Editor and Power BI Desktop is always consistent with the Regional date format of your computer. It uses the short date format in Power Query Editor and uses the long date format in Power BI Desktop. You can change computer's format in Settings > Time & Language > Region. This will change the default format in Power BI Desktop Application as this behavior is automatically detected if a column is in date type.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[amitchandak]

@Anonymous , You can change the format under column tools. Once you click on column you will get that

[Anonymous]

Hi,

I have already mentioned before that I am already changing manually either going to Column tools in Data View or Property pane in Model View (image inserted in the previous message).

I am looking for the best option to sort the issue permanently.

As of now, I have to do the editing for each column manually.

Thanks.