Forum Discussion
Solved
How do I format a date field?
The current values in a date field are being displayed as Saturday, March 14, 2026 and I would like to simply display as 3/14/2026 I'm sure this is easily formatted but I can't seem to find t...
Hello,
Click on the field, and then Column tools - Format:
- Select the date column in the Fields pane.
- Go to the Column tools tab in the ribbon.
- In the Format dropdown, choose Short Date.
Rnaval Hey,
You have plenty of options.
In the column/measure settings, you can write whatever format you want or select from predefined ones.
I find it most convenient and stable when I define it myself, the logic is:
y = Year
M (capital) = Month
d = day
So for yours it would look like MM/dd/yyyy
Please note that if it's a Date column, the separators may be affected by your regional settings, if you want stricly certain format, add a new column to your dimension as Text, either in Power Query or in DAX.
In DAX:
dateFormatted = FORMAT( 'Table'[date], "MM/dd/yyyy")