DataFormat:Error Date time type

[doraemon0041]

Query fail to parse Date Time type for a single day on 29/02/2020 but other days seem to work just fine.Please help.

Data Set

https://1drv.ms/u/s!Ag--FcYGeIfNay7NCdnc1kJrMmc?e=cN5ofw

[v-juanli-msft]

Hi @doraemon0041 

As tested, if i set the regional setting in Power BI as windows default display language, it works for this kind of date format from data source.

I can't open your excel file since it exceeds 5 MB file size limit.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@doraemon0041 ,

I think it may be because of other dates in mm/dd/yyyy format or date less than 12. If you want all dates to be in dd/mm/yyyy format. refer : https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/...