Forum Discussion
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.
IreliaSama It's the h:nn:ss format
4 Replies
- AnalyticPulseSolution Sage
format option is vailabe in data view. you can choose from there.
- IreliaSamaNew Member
thank y'all... I'll try those options
- Greg_DecklerCommunity Champion
IreliaSama It's the h:nn:ss format
- AnonymousNot 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.