# Display empty values in report charts

**URL:** <https://community.hubspot.com/t/display-empty-values-in-report-charts/42541>\
**Category:** HubSpot Ideas\
**Tags:** reports\
**Created:** [August 19, 2021, 6:42am UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541 "2021-08-19T06:42:08Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![nellp](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/nellp/32/90652_2.png) [@nellp](https://community.hubspot.com/u/nellp)\
**Post date:** [August 19, 2021, 6:42am UTC](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541/1 "2021-08-19T06:42:08Z")

</div>

A standard feature in most diagram/chart-creation is to “display empty value”, so I currently don’t understand why Hubspot reports does not have this functionality.

For uniform and comparable charts across several roles (e.g. overview of tasks for several people, company lead status or deal stage per salesperson etc.) this would be very valuable.

To clarify, I don’t mean the filter “[Value] \> _Is none/empty_”, but rather empty values on the x-axis of a chart like this one:

 ![image-Aug-13-2021-03-20-48-67-PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/9/f/9ff22e31a2b1474ad7b68c677f50f7e6da201c9f.png)

Hubspot support confirms that this is currently not possible without creating a custom property for each point on the x-axis. This is an incredibly bulky workaround for something as simple as wanting to see (for example) all the lead status’ regardles of the number of contacts/companies with each status. It’s also practically impossible when the x-axis displays, for example, dates or periods of time. I would argue that statistically speaking, “none” is **as** significant as “less/more than none”.

Here’s a side-by-side of two identical\* charts where the only difference is the ‘company owner’ property, where the value of a “show empty values” toggle would be incredibly useful to give a better overview at-a-glace, and avoid confusion.

(\*) I’ve changed the colours on the chart on the right, but it’s worth noting that Hubspot does not assign consistent colours to the same value on different charts. “In progress” can be blue on one and purple on another, based on how many values the chart is displaying)

 ![Capture.JPG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/6/d/6dffd2cb0516900a640f5bf361e18bdd73e8e814.jpeg)

---

_[View the full topic](https://community.hubspot.com/t/display-empty-values-in-report-charts/42541)._
