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/...
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
@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
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
