Forum Discussion
DD/MM
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 !
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.
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.
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
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.
