Hide Blanks
Last updated
Last updated
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.
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
In Chart Options, you will find the Hide Blanks options as shown image below:
This option displays the complete ragged hierarchy, including the blank records, as seen below:
With this option, the blank record along with its all-child values will be removed from the visual display.
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.
With this option, the blank records will get eliminated from the visual display, but its child records will be retained.
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.
Try the xViz Gantt Chart (Microsoft certified) for Power BI from Microsoft AppSource here.