Forum Discussion

BenBallantine's avatar
BenBallantine
Frequent Visitor
3 years ago

Power BI Report Visual for duration

I'm struggling to create a power BI visual showing outages types with their respective durations against them. This is one aspect of the data I'm looking to use and as you can see it's in 'time' for...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

BenBallantine , Duration is a datatype in Power query and it is different from time. But DAX you do not have it. So leave it like that

 

for the sum of time refer

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

BenBallantine's avatar
BenBallantine
Frequent Visitor
3 years ago

Thank you amitchandak for the very quick response. I'm not sure this has answered my question. The root-cause of the problem is when I try and load duration and outage title to a Power BI Visual I get a 'count of duration outage' when I need duration displayed across the bottom as 'hh:mm:ss'.