Resource Gantt

In xViz Gantt Visualization, switch to Gantt Resource mode for a view tailored for resource planning and allocation.

The Gantt Resource Chart can also show the timeline of projects with multiple phases.

Consider having the following data of Task for projects, each with five stages and the start and end time execution in various phases.

Figure 1: Sample data for task and phase

Below is an example of the Gantt resource displaying the task and its phases. The below view gives a clear representation of the start-to-end execution time of all the tasks between multiple phases. The timeline bars have been color-coded by the phases.

Figure 2: Gantt Resource Mode in xViz Gantt Chart

The above view gives a clear representation of the start-to-end execution time of all the tasks between multiple phases. The timeline bars have been color-coded by the phases.

Steps to configure:

1. Data fields set up:

Insert the following columns in the ‘Task Name’ data field:

Category defining the rows – in this case, ‘Task.’

Category defining the phases in the timeline – in this case, ‘phase.’

Figure 3: Data Field to configure Task Name

2. Configuration:

To plot the timeline bars related to one task in one line:

Go to the Format Pane -> Chart Type -> GanttResource.

Figure 4: Gantt Resource Chart Type option

3. Formatting:

Color coding of the timeline bars:

Use the Conditional formatting feature from the Advanced Editor:

Figure 5: Conditional Formatting - Advanced Editor

And define different rules for color-coding the timeline bars. You can set conditions for different chart elements like Progress, Milestone, Timeline Bar etc.

Figure 6: Conditional Formatting - Chart elements

You can set conditions for different chart elements like Progress, Milestone, Timeline Bar etc. In the above example, phases of the same Task have been given the same color. You may choose to color code the bars based on Phases, instead of Tasks.

Note: Conditional Formatting feature requires inserting minimum one numeric data in the visual.

To enable Conditional Formatting, can insert the measures/numeric data in the Display Measure Data Field. Further, you can disable the Measure from showing in the visual using Formatting Pane.

Figure 7: Data Fields to configure Display Measures

By using the toggle off/On options, we can disable the measure displaying from the visual using Formatting Pane.

Reference: How to manage multiple phases of projects in Power BI using Gantt Chart (xviz.com)

---

Try the xViz Gantt Chart (Microsoft certified) for Power BI from Microsoft AppSource here.