Forum Discussion
Excel Analysis - date vs. text
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 wh...
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?
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.