Gantt chart
Last updated
Last updated
Analytics+ 4.5 ships with the best-in-class Gantt chart for Power BI. With the fully customizable Gantt chart, you can visualize task schedules, identify dependencies, allocate resources, and track deadlines.
The multi-level timeline enables capturing progress at a detailed level.
Use connectors to visualize project-level dependencies.
Apply conditional formatting to quickly identify status/risks.
Track process completion with milestones and custom reference lines.
Let's look at how to build a Gantt chart with Analytics+.
STEP 1: Select the Gantt option from the landing page. You'll notice that there is an additional 'Gantt fields' visual parameter. You can add Gantt-related dimensions like the start/end dates, milestones, connectors, and tasks/subtasks associated with the project.
STEP 2: Let's map the basic fields required for a Gantt—the tasks involved in a project and the start and end dates for the tasks. Please bear in mind that the start and end dates have to be added to the 'Gantt fields' parameter. You can then map the Start date and End date in the Pivot data window.
STEP 4: Once we've determined the tasks and subtasks, we need to know the actual progress of each category. Let's add 'Progess' to the Value parameter and map it in the Pivot data window. You'll be able to see the progress made for each subtask as well as the overall progress made for each task.
STEP 5: As part of tracking, it is critical to determine who is responsible for each task/subtask. Let's assign the 'Resource Name' to the Gantt fields parameter and map it in the Pivot Data window.
STEP 6: You can display additional dimensions and measures by adding them to the Display category and Display measure data wells. To demonstrate this, let's display the progress status value in our Gantt.
STEP 7: Capturing milestones is a major part of planning and project tracking. You can add milestones to the Gantt Fields parameter and display them in the progress bars.
STEP 8: Interdependencies are inevitable in any project. It is crucial to capture dependencies for proper planning. Add connector lines by assigning data to the Connect to field.
STEP 9: We can capture sprints of phases in the project with reference lines. Since Gantt charts are timeline-based, you can choose between the following options:
first-of-date: The earliest date plotted in the Gantt.
last-of-date: The latest date plotted in the Gantt.
Today: Current date
Custom date: Select a date from the date picker.
In this case, we've plotted a reference line for the current date and additional reference lines that signify the end of each phase in the project.
We'll also highlight the initial planning phase with a reference band by choosing the Custom Date Range option.
STEP 10: Tracking the planned start and end dates is critical in maintaining deadlines and comparing the progress between the actual and planned dates. Let's add the planned dates and map them to the respective buckets in the pivot data window.
STEP 3: Next, we'll break down the Development/Design/Requirements by adding the Sub Task field. Click the icon to expand the tasks and display all the related sub-tasks.
STEP 11: Now let's beautify our Gantt chart a little bit. We'll open Canvas settings to change the appearance of the progress bars and milestones. .
