How to Fix This Date Column Format in Power BI itself

[AlanP514]

Hai Team,

I need some help, in this  Sc Attached facing an error

Column called ticket Date, But Few Dates are like 

1/1/2023, Few are like 1/1/23, Due to this error is showing how to fix this

[pankaj_lp]

Its probably due to the default settings as dd/mm/yyyy format , try changing it to mm/dd/yyy

[serpiva64]

Hi, 

your example is not completely clear to me.

in row 102 the date is 22 of february 2013?

in row 103 the date is 2 of november 2013?

If it is so you can change type using local and you get no error

from this

using locale

you get 

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !