How do I change the date to a UK format before changing data type?

[HamidBee]

Hi All, 

How do I change the date format so that it is dd/mm/yyyy so that when I change the data type it changes without any errors?

 

[amitchandak · Accepted solution]

@HamidBee , Option one change system setting

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/...

Option two create a new column

DD/MM/YYYY to MM/DD/YYYY
date(year( right(DD__MM__YY[date],4)), month(mid(DD__MM__YY[date],4,2)) ,day(left(DD__MM__YY[date],2)))

MM/DD/YYYY to DD/MM/YYYY
date(year( right(DD__MM__YY[date],4)), month(left(DD__MM__YY[date],2)),day(mid(DD__MM__YY[Version_Id],4,2)) )