Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
amaoa
Helper II
Helper II

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

time_1.png

Image 2

time_2.png

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

Data Format New Rib.png

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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

Data Format New Rib.png

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.