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.

GIF 1: Hide blank nodes configuration in Gantt Chart

Steps to configure:

There are multiple options available to handle blank values. To use the available option from Hide Blanks. First, go to Format Pane, navigate to the Chart Options

Image 1: Chart Options in Format Pane

In Chart Options, you will find the Hide Blanks options as shown image below:

Image 2: Hide Blanks options

Display All:

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

Image 3: Display All

Image 4: 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.

Image 5: Sample Data for Hide Blanks

Image 6: Data after 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 bottom 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.

Image 7: Hide Blanks

Image 8: 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.

Image 9: Sample data for Hide Intermediate Blanks

Image 10: Data after 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.

Image 11: Hide Intermediate Blanks

Image 12: Hide Intermediate Blanks Configuration

---

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