Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date/Time format

Hi, struggling to figure out how to change date/time format in PowerBI. I have bunch excel files that include a column called Time in a following format:   7/5/2021 6:00:00 AM  - mm/dd/yyyy hh:mm ...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    Indeed, sometimes I encounter this situation, I usually solve it like this. You can try to change type with locale.

     

    Best regards

     

    Janey guo

    Community Support Team _ Janey
    If this post helps, please consider accept as solution to help other members find it more quickly.
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, Anonymous 

 

Indeed, sometimes I encounter this situation, I usually solve it like this. You can try to change type with locale.

 

Best regards

 

Janey guo

Community Support Team _ Janey
If this post helps, please consider accept as solution to help other members find it more quickly.