DD/MM

Question

Is there a way to set a Display format of a date column to DD/MM.converting to text is not realy an option, I can't sort the column by the date due to multiple entries ....

v-xjiin-msft · Answer

Hi&nbsp;Anonymous,&nbsp;In your scenario, you want to format date values to a specific format as "DD/MM". Right?&nbsp;To achieve your requirement, you can create a calculated column and try Format() function. Please refer:&nbsp;Column = FORMAT('Calendar table'[Date],"DD/MM")&nbsp;Hope it works for you.&nbsp;Thanks,Xi Jin.

greg_deckler · Answer

I count about 80 date/time formats but that's not one of them.

anonymous · Answer

I know.In europe we always are placing days before months, and in visuals with a lot of data we can often skip the year.This makes us gain quite some space.&nbsp;Frustrating !

greg_deckler · Answer

v-xjiin-msft- Except that converts it to text, which he doesn't want to do. Sounds like he wants to keep it as a date but have it display DD/MM. It's the same issue people have with Duration, sure you can convert it to text and display it HH:MM: SS but they want it as a number that can be graphed but have it displayed that way.

anonymous · Answer

Completelly true ....Can't get it that in such a international world 80% of the formats are only US formats.Don't know what Asia is doing but Europe and Afrika are dd/mm/yyyy adicts instead of mm/dd

Forum Discussion

DD/MM

6 Replies

Related content

Date Formats - MM/DD/YYYY to DD/MM/YYYY

how to change date format --- mm-dd-yyyy to dd-mm-yyyy in power bi

Change Date Format to MM/DD/YY

Date issue - dd/mm/yyyy vs mm/dd/yyyy

unable to change date format mm/dd/yyyy to dd/mm/yyyy