Forum Discussion
Visualize/quantify gaps in time between successive start and end times for IDs with multiple records
Thanks. I've done something similar with the Gantt visual in the past (showing records of same type in the same row using start and end dates), but it seems like it doesn't behave the same with time in the equation.
Attached is an example of some of my data. You can see that the record with the inset shown isn't displaying correctly (the actual data is 10 pm to 11:21 am, but it is showing 24 hours beginning at 10 am). This is occurring across records and causing a lot of weird overlap that doesn't exist.
Data types are correct, etc. Have calculated duration and used that instead of end date and same problem occurs.
Any thoughts? Can anyone confirm/deny if Gantt visual just does not properly support time?
Looks like not, but there are some solutions in this thread that might work for you: https://community.powerbi.com/t5/Desktop/24-hour-based-gantt/td-p/83892
Thanks. I had come across that thread but I think the granularity of the time data I have makes it a bit too cumbersome. I've come up with some another solution to sort of solve my problem... calculating the duration difference between successive records and conditionally formatting those that are greater than we'd like.
Not quite what I was shooting for with the Gantt visual, but works well enough.
Yeah, calculating the difference and making a bookmark button that filters for > whatever threshold maybe. The conditional formatting "bars" in tables seem to stand out really well as a size indication.