Forum Discussion

RadkaJanska's avatar
RadkaJanska
New Member
4 years ago

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 why? What shall I do?

Thanks,

Radka

Need Help

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    4 years ago

    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's avatar
      RadkaJanska
      New Member
      4 years ago

      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. 

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    4 years ago

    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!