# Reporting: Show properties in legend, labels with zero values/zero count

**URL:** <https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201>\
**Category:** HubSpot Ideas\
**Tags:** reports\
**Created:** [January 4, 2022, 6:10pm UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201 "2022-01-04T18:10:05Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![NicoleJ](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/nicolej/32/76591_2.png) [@NicoleJ](https://community.hubspot.com/u/NicoleJ)\
**Post date:** [January 4, 2022, 6:10pm UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/1 "2022-01-04T18:10:05Z")

</div>

Business need: when reporting on something like deal counts per territory, it would be nice if the report could also show territories that have a _zero count._ This would be helpful when presenting the report to others, to have a visual cue that all territories (or whatever property you’re using) is being represented, even if they have a zero count.

---

<div class="post-metadata">

**Author:** ![Otterbot](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/otterbot/32/77566_2.png) [@Otterbot](https://community.hubspot.com/u/Otterbot)\
**Post date:** [February 10, 2022, 9:34pm UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/2 "2022-02-10T21:34:20Z")

</div>

Seconding this idea. We would like to include a report in our sales dash that shows the counts of deals in various stages. If there are 0 deals in a particular stage, that stage just completely disappears. It would be very helpful to be able to still include report column headers / categories when there are 0 counts.

A similar Idea to upvote is here: [https://community.hubspot.com/t5/HubSpot-Ideas/Show-labels-with-no-value-in-report/idi-p/434130](https://community.hubspot.com/t5/HubSpot-Ideas/Show-labels-with-no-value-in-report/idi-p/434130)

---

<div class="post-metadata">

**Author:** ![EBamonti](https://avatars.discourse-cdn.com/v4/letter/e/bbce88/32.png) [@EBamonti](https://community.hubspot.com/u/EBamonti)\
**Post date:** [May 14, 2022, 7:15pm UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/3 "2022-05-14T19:15:32Z")

</div>

yes! This would be super helpful to see full scope of properties and counts!

---

<div class="post-metadata">

**Author:** ![JOpie](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jopie/32/87988_2.png) [@JOpie](https://community.hubspot.com/u/JOpie)\
**Post date:** [May 24, 2022, 11:03am UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/4 "2022-05-24T11:03:56Z")

</div>

Totally agree! HubSpot sometimes treats zero as being equal to null: zero is a value all on its own!

---

<div class="post-metadata">

**Author:** ![JFabregas](https://avatars.discourse-cdn.com/v4/letter/j/71e660/32.png) [@JFabregas](https://community.hubspot.com/u/JFabregas)\
**Post date:** [July 12, 2022, 11:20pm UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/5 "2022-07-12T23:20:24Z")

</div>

upvoting this idea as we also need this in the report

---

<div class="post-metadata">

**Author:** ![KCurrie](https://avatars.discourse-cdn.com/v4/letter/k/ee7513/32.png) [@KCurrie](https://community.hubspot.com/u/KCurrie)\
**Post date:** [November 24, 2022, 12:20am UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/6 "2022-11-24T00:20:58Z")

</div>

If this feature were available, it would save me many extra steps to get a complete set of company data, even when the activity count is zero to manage my account management team.

---

<div class="post-metadata">

**Author:** ![BFrischknecht](https://avatars.discourse-cdn.com/v4/letter/b/958977/32.png) [@BFrischknecht](https://community.hubspot.com/u/BFrischknecht)\
**Post date:** [June 27, 2023, 4:23pm UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/7 "2023-06-27T16:23:40Z")

</div>

Yes, this has long been a frustration for me. Most of the time the audience doesn’t know what they should be seeing so they won’t recognize when data values (categories) have been left from a table or chart. Showing all the values for a property would be very helpful.

It would also help with visual presentation because the size and shape of the chart won’t change based on the number of unique values with data present for a particular property.

---

<div class="post-metadata">

**Author:** ![ecandgs](https://avatars.discourse-cdn.com/v4/letter/e/96bed5/32.png) [@ecandgs](https://community.hubspot.com/u/ecandgs)\
**Post date:** [July 11, 2023, 7:54pm UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/8 "2023-07-11T19:54:24Z")

</div>

Upvoting - we really need this as well for custom reports.

---

<div class="post-metadata">

**Author:** ![just4werk](https://avatars.discourse-cdn.com/v4/letter/j/c68b51/32.png) [@just4werk](https://community.hubspot.com/u/just4werk)\
**Post date:** [January 23, 2024, 11:59pm UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/9 "2024-01-23T23:59:30Z")

</div>

We need this. Thanks.

---

<div class="post-metadata">

**Author:** ![BMcRae](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/bmcrae/32/196692_2.png) [@BMcRae](https://community.hubspot.com/u/BMcRae)\
**Post date:** [March 13, 2024, 1:49pm UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/10 "2024-03-13T13:49:11Z")

</div>

Need this for reports!

---

<div class="post-metadata">

**Author:** ![jdickson34](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jdickson34/32/5125_2.png) [@jdickson34](https://community.hubspot.com/u/jdickson34)\
**Post date:** [June 30, 2024, 12:52pm UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/11 "2024-06-30T12:52:19Z")

</div>

This limitation is fine if you have a handful of people using HubSpot, but it alienates your larger users like myself who have 50-100+ Sales Reps and Marketers!

---

<div class="post-metadata">

**Author:** ![lfontana](https://avatars.discourse-cdn.com/v4/letter/l/f04885/32.png) [@lfontana](https://community.hubspot.com/u/lfontana)\
**Post date:** [August 19, 2024, 10:31am UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/12 "2024-08-19T10:31:23Z")

</div>

Upvoting

---

<div class="post-metadata">

**Author:** ![KGrupeGehle](https://avatars.discourse-cdn.com/v4/letter/k/87869e/32.png) [@KGrupeGehle](https://community.hubspot.com/u/KGrupeGehle)\
**Post date:** [August 21, 2024, 2:28pm UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/13 "2024-08-21T14:28:08Z")

</div>

We need 0 counts as well! Without this feature, we have to export the data into a spreadsheet in order to track month over month, which is very time consuming.

---

<div class="post-metadata">

**Author:** ![brooke-Monad](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/brooke-monad/32/13916_2.png) [@brooke-Monad](https://community.hubspot.com/u/brooke-Monad)\
**Post date:** [November 24, 2025, 6:26pm UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/14 "2025-11-24T18:26:29Z")

</div>

This is really important for accurate reporting.

---

<div class="post-metadata">

**Author:** ![emerson](https://avatars.discourse-cdn.com/v4/letter/e/c77e96/32.png) [@emerson](https://community.hubspot.com/u/emerson)\
**Post date:** [October 26, 2026, 4:34pm UTC](https://community.hubspot.com/t/reporting-show-properties-in-legend-labels-with-zero-values-zero-count/49201/15 "2026-10-26T16:34:49Z")

</div>

Here looking for this feature in 2026 - 4.5 years after NicoleJ called it out - still nothing. Not even a toggle that would allow a user to turn this on or off.
