Date Formats using Project Online Data

[amaoa]

Hello All,

My data source is from project online. I have two different date formats as shown in image 1 below. When I click Transform data, right click on the column to change from Date/Time to just Date, I get the second image with long date versions. How can I make the date format into MM/DD/YY (1/20/20) or DD-MM-YY (20-Jan-20)? Any help will be greatly appreciated. Thanks

Image 1

Image 2

[amitchandak · Accepted solution]

@amaoa , if you date are in UK format and you want to work with those -https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/...

Check an option in data format (screenshot at last) or under formatting string for that :https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

Else create a date string like (if it is detected as date )

Format([Date],"dd-mm-yy")

Format([Date],"mm-dd-yy")

Format option