Power BI TIME Formatting Made Simple || Convert Seconds to mm:ss or hh:mm:ss !!

Say Goodbye to Manual Text Conversion. Don't convert your numbers into Text to get to mm:ss or hh:mm:ss. Do it the proper way in Power BI, save time and improve your efficiency !!!

In this video, I will show you how to convert your duration data from seconds to HH:MM:SS or MM:SS in Power BI in an easy and simple way.

Yes Power BI formatting option is a little limited, but there are creative ways to make the best of Power BI, such as using one of these 3 methods:
- Field Column Formatting
- Measure Dynamic Formatting
- Formatting using DAX (Format + Time Combo)

Hope you find this Power BI video useful in your learning journey.

See you next time,

Cheers,
Isabella Susilowati
@LighthouseAnalytix
#powerbi_training , #powerbitips , #powerbitutorial. #powerbitutorialforbeginners

Timeline
01:33 Fields Column Formatting
02:38 Measure Dynamic Formatting
04:52 Formatting using DAX.

License code: 5VDRGSJQGPQGINU6

LA123

[jessielivermore]

I'm relaxed AND learning something new at the same time! Thank you Isabella.

[Dansel_B]

wow! that was a great trick! thank you, beautiful Isabella 😘 please make more videos on DAX PBI

[allyitaly]

Wow, it's great! You are fabulous! You saved my life :) Thanks a lot! <3

[black_south]

Hello ni would like to thank you about that video it's really helpfull, but i have a question if i have average handling time for each call per agent and i i don't want to Summarize the hall coulmn how i can do it so i can vizualize the AHT for each agent

[gauthamk]

Awesome! as usual, I'm flattered with your voice

[HaroldsPurpleCrownTraining]

Nice video! Chelsie Eiden's Duration solves all these issues. You can aggregate time too.

[kfkjvdb]

Thank you for the tutorial,
Btw why I cannot drag "Test duration 2" to Y axis after i covert follow your formula??

[priyal_]

Can you tell me one more thing.
I am taking data from SQL server and then transforming the data. But it gives me one error when I close and apply


ODBC error data source error, Microsoft SQL Execution Timeout expired . The timeout period elapsed prior to the completion of the operation or the server is not responding. An unexpected exception occurred

[priyal_]

Hi
I know off topic but, I have a power bi report which has a huge data model. Is there any way by which we can understand how is it created

[lautaroramos]

I was trying to apply the third option but my sum went over 24 hours, so i can’t display the data labels. is there any way to solve this?

[Bedrock-Tech-Talks]

The third option is great and seemed to work at first but then my sum went over 24hours and it broke :(