Hide Blanks

In the Gantt one of the most common scenarios is ragged or uneven hierarchies.

The xViz Gantt Chart provides the ability to hide the blank nodes which appear in case of ragged hierarchies.

Figure 1: Hide blank nodes configuration in Gantt Chart

Steps to configure:

There are multiple options available to handle blank values. This configuration is available in the Format Pane -> Chart Options -> Hide Blanks.

• Display All: This option displays the complete ragged hierarchy, including the blank records, as seen below:

Figure 2: Display All Ragged hierarchies in xViz Gantt Chart

• Hide Blanks: With this option, the blank record along with its all-child values will be removed from the visual display.

Figure 3: Sample Data for Hide Blanks

In the above example, ‘REQUIREMENTS’ is a parent node and its direct child records are a blank record, ‘Kick Off meeting,’ ‘Project Plan,’ ‘Requirements Gathering ' in the left image, all the blank records are displayed. In the right-side image, you can see that the Hide Blanks option eliminates the blank record along with the child values like ‘Phase I’ from the visual display.

Figure 4: Hide Blanks configuration in xViz Gantt Chart

• Hide Intermediate Blanks: With this option, the blank records will get eliminated from the visual display, but its child records will be retained.

Figure 5: Sample data for Hide Intermediate Blanks

In the above example, only the blank records from the parent and the child nodes will get eliminated from the visual display. ‘REQUIREMENTS’ is a parent node and its direct child records are a blank record, ‘Kick Off meeting,’ ‘Project Plan,’ ‘Requirements Gathering ' in the left image, all the blank records are displayed. In the right-side image, you can see that the Hide Intermediate Blanks option eliminates the blank record and retain the child values like ‘Phase I’ from the visual display.

Figure 6: Hide Intermediate Blanks Configuration

---

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