# Prevent Report Data Labels From Showing Zero Values

**URL:** <https://community.hubspot.com/t/prevent-report-data-labels-from-showing-zero-values/94754>\
**Category:** Dashboards & Reporting\
**Tags:** enterprise\
**Created:** [November 24, 2023, 10:18pm UTC](https://community.hubspot.com/t/prevent-report-data-labels-from-showing-zero-values/94754 "2023-11-24T22:18:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![OMueller7](https://avatars.discourse-cdn.com/v4/letter/o/df788c/32.png) [@OMueller7](https://community.hubspot.com/u/OMueller7)\
**Post date:** [November 24, 2023, 10:18pm UTC](https://community.hubspot.com/t/prevent-report-data-labels-from-showing-zero-values/94754/1 "2023-11-24T22:18:06Z")

</div>

I’m wondering whether its possible to prevent a report’s data labels from displaying zero-values (e.g. “US$0” - underlined in red in the screenshot below).

 ![HS Custom Report Zero Value Data Labels.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/1/156fe13041e8a44074418ff7f391730f814d9aba.png)

I’ve tried filtering out zero values and changing the axes minimums, but neither has worked.

For context, this is a custom report builder report displaying amount sums by close date, which is ‘broken down by’ a geographic variable.

Appreciate any ideas/suggestions!

---

<div class="post-metadata">

**Author:** ![franksteiner79](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/franksteiner79/32/34443_2.png) [@franksteiner79](https://community.hubspot.com/u/franksteiner79)\
**Post date:** [November 25, 2023, 10:43am UTC](https://community.hubspot.com/t/prevent-report-data-labels-from-showing-zero-values/94754/2 "2023-11-25T10:43:11Z")

</div>

Hi @OMueller7

If you click into the zero values, what sort of deals are you seeing then?

Which amount/value property are you displaying in the report?

Are you filtering out deals that don’t have any values for that property?

Frank

---

<div class="post-metadata">

**Author:** ![OMueller7](https://avatars.discourse-cdn.com/v4/letter/o/df788c/32.png) [@OMueller7](https://community.hubspot.com/u/OMueller7)\
**Post date:** [November 27, 2023, 3:50pm UTC](https://community.hubspot.com/t/prevent-report-data-labels-from-showing-zero-values/94754/3 "2023-11-27T15:50:27Z")

</div>

Hi @franksteiner79, appreciate the response!

1. clicking on zero-values gives me a: “There is no data to show in this time frame. Try changing the date range.” message.

2. I am displaying the ‘Forecast amount’ property and am filtering out amounts \<1 (filtering by ‘is known’ doesn’t change things).

I’ve been able to replicate the zero data labels by graphing deal counts and normal deal amounts and using the ‘Break down by’ a property. This seems to force the report into displaying data labels each sub-category of said property (e.g. each geographic region), even if there is no data for said sub-category.