DD/MM

[Anonymous]

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 ....

[Greg_Deckler]

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

[Anonymous]

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.

Frustrating !

[v-xjiin-msft]

Hi @Anonymous,

In your scenario, you want to format date values to a specific format as "DD/MM". Right?

To achieve your requirement, you can create a calculated column and try Format() function. Please refer:

Column = FORMAT('Calendar table'[Date],"DD/MM")

Hope it works for you.

Thanks,
Xi Jin.

[Greg_Deckler]

@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]

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

[v-xjiin-msft]

Hi @Anonymous,

Generally, we just use YYYY-MM-DD as date format.

So, you want the DD/MM still be date format. However, as I know in date formats there only exists something like "MMMM/D" (March 14) which obviously doesn't satisfy your requirement. Thereby I'm afraid your requirement cannot be achieved in current Power BI desktop.

Thanks,
Xi Jin.