Forum Discussion

IreliaSama's avatar
IreliaSama
New Member
2 years ago
Solved

Time Formatting in PowerBI

Hello I Need help with the snapshot below. I want to know how to change the format similarly to the excel file.

 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi IreliaSama ,

     

    Thanks for sharing AnalyticPulse  and Greg_Deckler , here are some more suggestions that I hope will help.


    This is actually handled after you load the data back into Power Bi Desktop, you're just changing the appearance of the time, PowerBi (and Excel) both record time values as decimal, it doesn't matter to the programme what you make it look like as long as the format is a valid time.

     

    To change the time format, you can select the time column you want to change in power bi desktop and then just select the desired format in the column tools.

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.