Skip to main content

Power BI

Under Review

Gantt by Time and Planned v Actual

Vote (344) 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 (43)
Clark's profile image Profile Picture

bc3f1b0b 9f9b-4f99-9ed0-cd863d054063 on 06 Jul 2020 00:13:31

RE: Gantt by Time and Planned v Actual

I'm not holding my breath. There are countless requests like this one for visualizing milestones (NOT date ranges) in swim lanes. Yes, there are custom visuals but they only support Start and End dates and they show a time range. We need to mark single dates such a registration date, abstract due dates, etc. and have the ability to add more than 2.

But MS doesn't care. They completely ignore those who might need to chart dates as they pertain to say, clinical trials and a GLOBAL PANDEMIC!

You can chart anything you want in Power BI as long as it financials and just numbers.

Clark's profile image Profile Picture

99f79c10 948f-48aa-9589-49f3ee6ec535 on 06 Jul 2020 00:08:43

RE: Gantt by Time and Planned v Actual

'An out of the box gantt chart is one of the visuals I want most. Every time I try to create a Gantt chart in Power BI I get extremely frustrated. Some features I think it needs:
- Abiltiy to nest tasks under a parent task to multiple levels
- Ability to have multiple records displayed on the same line based on a name column for example. This would should multiple date/time bands on a single row
- Ability to control the color based on conditional formatting, or a value from another field (column or measure)
- Ability to control the zoom level more than just by second, minute, hour, day, week, month, etc. I would like to have zoom in and out capabilities like you do a map

Clark's profile image Profile Picture

8890d147 b7a1-4d3e-bcd9-cec8bdd72928 on 06 Jul 2020 00:05:27

RE: Gantt by Time and Planned v Actual

There is a new gantt chart available with the ability to track actual and planned values - https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000891?tab=Overview

https://xviz.com/blogs/gantt-chart-advanced-custom-visuals-for-power-bi/

Clark's profile image Profile Picture

35d42a17 e4a0-4fb1-98d9-f2238021c04a on 06 Jul 2020 00:05:08

RE: Gantt by Time and Planned v Actual

We need a standard visual for Gantt charts. Soon, please!

Clark's profile image Profile Picture

98b891bf 2827-4fce-a48f-607a62e3b138 on 05 Jul 2020 23:59:29

RE: Gantt by Time and Planned v Actual

very much needed based on hour and minutes.

Clark's profile image Profile Picture

fede0ed6 c054-4902-8424-536b41bd6a09 on 05 Jul 2020 23:56:52

RE: Gantt by Time and Planned v Actual

I agree with these comments, finer granularity os very much needed.

Clark's profile image Profile Picture

98eacf84 d324-4164-95ef-e6649b7df0c4 on 05 Jul 2020 23:51:47

RE: Gantt by Time and Planned v Actual

I would love this in hours minutes and seconds as I do have tasks which take a few seconds and I need to represent that

Clark's profile image Profile Picture

3cda212e 85ef-4a09-b863-253ae3fe70df on 05 Jul 2020 23:51:02

RE: Gantt by Time and Planned v Actual

I spent sometime looking at the Gantt Chart capabilities of Tableau. We need something similar in Power BI. below links are some videos showing that

https://www.youtube.com/watch?v=r_B3M5KYiQU
https://www.youtube.com/watch?v=22H4ttDVl5c&t=151s

Clark's profile image Profile Picture

3cda212e 85ef-4a09-b863-253ae3fe70df on 05 Jul 2020 23:50:56

RE: Gantt by Time and Planned v Actual

would love to have ability to change bar formatting and add milestone diamonds. also, track baseline vs. actuals, and expand and collapse WBS elements. similar to what you can do in ms project or primavera

Clark's profile image Profile Picture

9f1025c0 f36b-4473-b226-359a422951a1 on 05 Jul 2020 23:48:37

RE: Gantt by Time and Planned v Actual

I need hour, grid line and color format