Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date format keeps changing in Power BI desktop

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.

 

 

 

Need Help
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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.

       

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    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.