Forum Discussion
DD/MM
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 ....
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
Solution Sage
Solution SageHi 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.