Excel Analysis - date vs. text

[RadkaJanska]

Hello world,

is it possible? It was working, date in power bi formated as dd.mm.rr was the same in powerpivot in excel (via excel analysis). But now it is not? It is formated as text. Do you know why? What shall I do?

Thanks,

Radka

[v-xulin-mstf]

Hi @RadkaJanska

Could you provide the screenshots of your issue?

And check for dirty data in your column.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[GilbertQ]

Hi @RadkaJanska 

What happens if you try and export from Power BI Desktop does that work as expected?

[GilbertQ]

Hi @RadkaJanska 

Can you confirm that you have got the data type set correctly on your column?

If it is a measure make sure that this is set to Date in the data type too?

[RadkaJanska]

Hi @GilbertQ ,

the data type in PBI is set correctly. It is not a measure, just column. I also set format date to cells in Excel, but it did not help.