topic Re: Suppress zero values in reporting (pivots & charts) in Reporting & Analytics

Suppress zero values in reporting (pivots & charts)

Probley — Wed, 15 Nov 2023 17:20:59 GMT

Is there a way to suppress zero values in reporting?

1) I have a pivot where I would prefer to have blanks instead of zeros.

2) I have a chart of status by pipeline where not all statuses apply to each pipeline. I'd like to be able to select which columns show for each pipeline. It seems that zero values are suppressed automatically, but only if it's zero for the status for all pipelines.

Betreff: Suppress zero values in reporting (pivots & charts)

MiaSrebrnjak — Thu, 16 Nov 2023 12:41:27 GMT

Hi @Probley,

Thank you for reaching out to the Community!

I did some testing in my account and I can confirm that this is expected behaviour. It seems it's not possible to show empty values in reports at this time. I found a relevant feature request in our Ideas forum which you could support with an upvote or share your feedback in the comments.

I also wanted to invite a couple of subject matter experts to this conversation to see if they have any insights or workarounds they could share with us:

Hi @Dan1, @KTownsend, @Bryantworks, do you have any advice for @Probley? Thank you!

Cheers
Mia, Community Team

Betreff: Suppress zero values in reporting (pivots & charts)

Probley — Thu, 16 Nov 2023 17:19:35 GMT

Thanks @MiaSrebrnjak!

Re: Suppress zero values in reporting (pivots & charts)

KamilManzar16 — Wed, 10 Sep 2025 11:36:38 GMT

I came here with same question but nervous to see that this is still under ideas and suggestion. Hope to see any solution soon.

Thanks.

Re: Suppress zero values in reporting (pivots & charts)

BérangèreL — Wed, 10 Sep 2025 12:16:19 GMT

Hi @KamilManzar16 and thanks for sharing your valuable feedback with us!

Have you tried with the workaround that @karstenkoehler suggests on this similar post "Suppressing zero values and duplicates on a pie chart"?

Also, I’ve noticed a similar idea already present in our Ideas Forum: Exclude months with no value from Report.
To contribute, you can upvote the existing idea and share more details about your specific use case in the comments.

I have added my upvote and will share this feedback internally for more visibility.

Thank you and have a great day!
Bérangère