Forum Discussion
Solved
Converting Date Format
Hi All, I am trying to convert yyyy-MM-ddThh:mm:ss to yy-mm-dd. Any help would be appreciated. Thank you! Sean
I figured this out. I had to convert at the query level, not at the design level.
Sean,
Choose the datatype as date instead of datetime and select the format as yy-mm-dd in Report view.
Refer to the first screenshot and box 3. Choose the datatype and format dropdown.
https://docs.microsoft.com/en-us/power-bi/desktop-data-view
If it helps, mark it as a solution
Kudos are nice too
I am unable to convert to date format. I tried that before posting.