Forum Discussion

nisha_deepak's avatar
nisha_deepak
Helper III
5 years ago

date field issue

i have date column which isto be formated to mm/dd/yyyy. That also correctly formated within power bi and created report using table visualization .In power bi it is showing correctly like this. ...
Need Help
Show and Tell
Tips and Tricks
AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

nisha_deepak 

 

Excel handles dates differently to Power BI, so you may need to format the Excel file separately. Only way around this would be to format the date in Power BI as a text column, so that the exact formatting is preserved on export to Excel, but this won't be able to be used in any calculations or sorting.

 

Excel data types: https://support.microsoft.com/en-us/office/data-types-in-data-models-e2388f62-6122-4e2b-bcad-053e3da9ba90#__toc327893213

Dates are actually just serial numbers counting number of days since Jan 1, 1900

 

Power BI data types; https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types

There is actually a date data type. 

 

Formatting (MM/DD/YYYY vs DD/MM/YYYY) is a different thing again to data type, so this does not get preserved on export.