Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Date Format for Gantt Chart

Hi,

 

While visualizing dates in the GANTT chart, the dates are read to be in US format, even though the region is set as United Kingdom in Power BI

 

Data:

desmon316_0-1669627930278.png

Visual:

desmon316_2-1669628010185.png

 

Regional Settings:

desmon316_1-1669627968015.png

 

Regards

Desmond

 

Status: Needs Info

Hi @desmon316 

If you change the Gantt chart to table visual , what does the date format look like? Is it the format you set for United Kingdom ?

 

Best Regards,
Community Support Team _ Ailsa Tao

 

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

Hi @desmon316 

If you change the Gantt chart to table visual , what does the date format look like? Is it the format you set for United Kingdom ?

 

Best Regards,
Community Support Team _ Ailsa Tao

 

desmon316
Frequent Visitor

Hi @v-yetao1-msft ,

 

When it is converted to a table it shows the dates in UK format, as in the image below. When I browse over the task timeline in the Gantt Chart Visual, the dates are shown in MM/DD/YYYY format. Any date which has DD greater than 12 is shown as 1 day task.

 

 

desmon316_0-1669709646294.png