Forum Discussion
dglsmason
11 years agoAdvocate I
Date Display Formats
Using Power BI Desktop to create reports and charts. What is the syntax for displaying dates in specific formats. For example, "01/25/2015" instead of "Monday, January 25, 2015". Etc. Thanks!
- 11 years ago
click on the time field in your model then you can click on Modeling in the Desktop ribbon and pick the desired date format
lax
7 years agoNew Member
Another option will be to use below formula
Create a custom column as below
formattedDate= RAW[OrderDate].[Year] &"-"& RAW[OrderDate].[MonthNo] &"-" & RAW[OrderDate].[Day]
Make sure you convert the source column to date-time data type