Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Date Format does not change on Region Settings

I have English (India) as Region Settings in Power BI Desktop. The dates in my imported excel files are in DDMMYYYY format, yet I am getting MMDDYYYY format.


In the image below, I'm using a Gantt chart. I want the circled dates to show "date only" not "date & time" and in DDMMYYYY format. Even if the date format can't be changed I want just remove the pesky time from AC Date which is actually displaying one day earlier than the actual date in the Data Table.

 

 

 

Need Help

5 Replies

  • SivaMani's avatar
    SivaMani
    Icon for Resident Rockstar rankResident Rockstar
    5 years ago

    Anonymous, Is this screenshot from Power BI Desktop or Service?

     

    try this format,

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Yeah. It's a Gantt 2.2.3 chart on Power BI Desktop. I tried the change format. It only changes the date format in the Data Table.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Updated the original post with a detailed screenshot.

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Sorry, I can't reproduce your issue. Are you using the latest version of desktop?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I'm using that Gantt 2.2.3 visual. Other does not seem to fit the data I have.