Analyze in Excel Using Incorrect formatting as TEXT

Question

Using "Analyze in Excel," I find that when I open the dataset in Excel columns (as opposed to measures) that are dates are formatted as text, not dates. There is no way to change the formatting.

I should also add that the pivot table recognizes the field as a date as I'm able to group by month/week.

THis is having a big impact on my users ability to sort our data.

Is anyone else experiencing this? Am I doing something incorrectly when setting up my data model?

anonymous · Answer

I have created a idea for this. Vote!&nbsp;https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/40346272-analyze-in-excel-date-columns-convert-text-da

anonymous · Answer

CatPhish&nbsp;,The issue is caused by that Power Pivot treats Date columns as text. I find several threads stating the same issue, I would recommend you report this issue in PowerPivot forum.https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c0253620-6ae0-46ea-8b6e-124e6c950239/powerpivot-dates-turn-to-text-in-excel?forum=sqlkjpowerpivotforexcelhttps://stackoverflow.com/questions/27913051/powerpivot-incorrectly-convert-date-value-to-text-in-pivot-tableRegards,Lydia

Forum Discussion

Analyze in Excel Using Incorrect formatting as TEXT

2 Replies

Related content

Best Practice Analyzer

Date format is incorrect for region

Incorrect turnover total

Measure returning incorrect value

Measure Total Incorrect