Transforming Data - Date Format Issue

[RickOShay]

Hi,

I have a report with several date fields that pulls in as: mm/dd/yyyy. When I pulled in my data, one of the date fields pulls in the data in my report a little different than the rest. It pulls it in by showing: Tuesday, Septemeber 22, 2020, Which is really annoying because I just want the date (not day of the week) and it's very hard to sort through. I went into transfrom data, and I can see where I can ensure that my data type is set to "date" but that does not resolve my issue. How do I fix/modify the date format?

Another date field pulls in the data by year and quater, which I kind of like, but I don't see where I have control over this formatting.

Thanks,

[HotChilli · Accepted solution]

In Data View, select the column header and you will see the ribbon change to 'Column Tools'.

There is a Format dropdown in the ribbon where you select the one you want

[RickOShay · Accepted solution]

I just figured it out.

The solution is once you select the field you want to add into your report, there is a new menu option called "Column tools" that appears at the top where you can control the format of the date.

Thanks,

[HotChilli · Accepted solution]

In Data View, select the column header and you will see the ribbon change to 'Column Tools'.

There is a Format dropdown in the ribbon where you select the one you want

[RickOShay]

Hi,

This does not really address my issue. I need to know how to transform Tuesday, Septemeber 22, 2020 into 09/22/2020. 

[amitchandak]

@RickOShay , Before importing make sure your system format is also mm/dd/yyyy

refer

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/...

or you have convert using

DD/MM/YYYY to MM/DD/YYYY
date(( right(DD__MM__YY[date],4)), (mid(DD__MM__YY[date],4,2)) ,(left(DD__MM__YY[date],2)))

MM/DD/YYYY to DD/MM/YYYY
date(( right(DD__MM__YY[date],4)), (left(DD__MM__YY[date],2)),(mid(DD__MM__YY[Version_Id],4,2)) )