Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

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' format:


I assume for it to work properly on a visual it needs to be in 'duration' data type but it's throwing an error when I try and convert it from 'time' to 'duration' data type.


Any help or tips would be appreciated.




Solution Sage
Solution Sage

Durations are converted to a decimal (in days) when loaded. Best practice is to leave it as a decimal, do your measures, and then format it at the end. Please see this article for more detail and examples.

Calculate and Format Durations in DAX – Hoosier BI




Microsoft Employee

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'.




Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors