Forum Discussion
Conversion
Hi, 1. Import data from the excel (attached), the datatype in power BI imported in Text Format. 2. Duplicated the column and changed the Data Type to Time and changed the format as below. ...
Icey
Community Support
Community SupportHi Anonymous ,
Duration data over 24 hours is not supported in Power BI currently. You can vote similar ideas here to improve Power BI.
If you need to use it for calculations, I suggest you to convert it to "Second". For specific steps, you can refer to another post of yours.
If you want to show it in cards, I suggest you to refer to this blog:
Calculate Duration in Days Hours Minutes and Seconds Dynamically in Power BI using DAX.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.