Forum Discussion
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 the option readily.
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.
3 Replies
Hello,
Click on the field, and then Column tools - Format:
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) = Monthd = 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")- Select the date column in the Fields pane.
- Go to the Column tools tab in the ribbon.
- In the Format dropdown, choose Short Date.
