Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
@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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |