Skip to main content

Power BI

Under Review

Gantt by Time and Planned v Actual

Vote (400) Share
Clark's profile image

Clark on 06 Apr 2016 23:28:24

The Gantt Visual should allow greater granularity i.e. include time: Hours, Minutes, Seconds. This should be part of the axis and duration.

An alternative to "Completion" could be an 'actual' input i.e. [Actual Started] and [Actual Ended]. This will show Planned v Actual in a Gantt.

Comments (50)
Clark's profile image Profile Picture

Deepa on 05 Jul 2020 22:59:11

RE: Gantt by Time and Planned v Actual

'+1 to hours and minute in Gantt chart.

Clark's profile image Profile Picture

Gabriel Grünberg on 05 Jul 2020 22:56:21

RE: Gantt by Time and Planned v Actual

This is a bit of a showstopper right now.

Prefered solution from my perspective is to base this on seconds.

ie. you input a whole number or decimal second value and get Power BI gives you options how you want to present it.

Dream scenario would be to have checkboxes for what you want to have as part of the value:
years, months, days, hours, min, seconds, milliseconds.

or just a couple of preconfigured settings:
d hh:mm:ss
hh:mm:ss
and so on.

Clark's profile image Profile Picture

Power BI User on 05 Jul 2020 22:55:29

RE: Gantt by Time and Planned v Actual

Hello Power BI Team, Is there any update on this ?

Clark's profile image Profile Picture

Tyler Boveington on 05 Jul 2020 22:55:08

RE: Gantt by Time and Planned v Actual

It would be nice include seconds too, to be able to analyze machine process durations. I am trying to create a graph that will show when a piece of equipment was on, idling, and off during the production shift . Thanks!

Clark's profile image Profile Picture

ROB on 05 Jul 2020 22:52:26

RE: Gantt by Time and Planned v Actual

'+1 for second or sub-second for process analysis

Clark's profile image Profile Picture

Power BI User on 05 Jul 2020 22:50:36

RE: Gantt by Time and Planned v Actual

Great to have granularity i.e. include time: Hours, Minutes, Seconds

Clark's profile image Profile Picture

Amr Atya on 05 Jul 2020 22:48:02

RE: Gantt by Time and Planned v Actual

'+1 for hours and minutes. Great idea

Clark's profile image Profile Picture

Jon on 05 Jul 2020 22:47:53

RE: Gantt by Time and Planned v Actual

'+1 for hours and minutes. Looking to create a dashboard to analyse SSIS packages and duration

Clark's profile image Profile Picture

David on 05 Jul 2020 22:47:34

RE: Gantt by Time and Planned v Actual

'+1 for minutes

Clark's profile image Profile Picture

Power BI User on 05 Jul 2020 22:47:23

RE: Gantt by Time and Planned v Actual

'+1 to hours and minutes Gantt visual