# 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](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FFRGM5kSReT8HnedJ5owe%2F0.gif?alt=media)

### **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

<figure><img src="https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FA1jRnbolYTOZL00r24Wp%2Fimage.png?alt=media&#x26;token=273c66da-5252-413c-86dd-96c848c5ccec" alt="" width="269"><figcaption><p><em>Image 1: Chart Options in Format Pane</em></p></figcaption></figure>

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

<figure><img src="https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FRBEIgt4YrhiCg0ZQyUhH%2Fimage.png?alt=media&#x26;token=05d399fe-a816-4677-bed8-19f7e02c4424" alt="" width="268"><figcaption><p><em>Image 2: Hide Blanks options</em></p></figcaption></figure>

### **Display All:**&#x20;

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

![Image 3: Display All](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FothrkFGC0WKDJF0LU18v%2F1.png?alt=media)

![Image 4: Display All Ragged hierarchies in xViz Gantt Chart](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FuqcbBUQ3M3O0czTW9Ref%2F2.png?alt=media)

### **Hide Blanks:**&#x20;

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](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FKXQK9sjQpJ1DCiw30vS8%2F3.png?alt=media)

![Image 6: Data after Hide Blanks](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2F2ggbvUMQCvdWz2KATTLw%2F4.png?alt=media)

{% hint style="info" %}
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.
{% endhint %}

![Image 7: Hide Blanks](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2Fv99ySUh1pOixLBnfejhr%2F5.png?alt=media)

![Image 8: Hide Blanks configuration in xViz Gantt Chart](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2F7k0JQEBcBvPucelEhlDX%2F6.png?alt=media)

### **Hide Intermediate Blanks:**&#x20;

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](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2Fv5UPhqm9Xz0oYyRgHi3S%2F7.png?alt=media)

![Image 10: Data after Hide Intermediate Blanks](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2Fx85FG5vt2QkoDGcxWTsu%2F8.png?alt=media)

{% hint style="info" %}
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.
{% endhint %}

![Image 11: Hide Intermediate Blanks](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2Fhpkr7UO7UQOh6lXtaogw%2F9.png?alt=media)

![Image 12: Hide Intermediate Blanks Configuration](https://382510089-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIuuIZWiXEx25eV75hmmJ%2Fuploads%2FHrb0e6umuy7Zv8mi3b4e%2F10.png?alt=media)

***

Try the [xViz Gantt Chart](https://xviz.com/visuals/gantt-chart/) (Microsoft certified) for Power BI from Microsoft AppSource [here.](https://appsource.microsoft.com/en-sg/product/power-bi-visuals/WA200000891?tab=Overview)&#x20;
