Forum Discussion
Date Formats using Project Online Data
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
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/599712
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
1 Reply
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/599712
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