Hello Team. I am trying to format a pivot table value field well which currently shows empty for some cells and want to replace these with a custom value. Please refer to the image below. The third row currently shows empty and ideally want to replace that with 0%. [image]

Hi, you can solve this with a calculated field and use coalesce(value,0).

Hi Arya, We are aware of this missing feature and are tracking this in our backlog.

Hello, Are there any updates on when this feature may be released?

Hello, I am still not able to replace blank with 0 using coalesce. Can you let us know if the feature is coming soon to handle blank with 0 or user to select and add values?

Hi - are there any updates on when this feature will make it to production?

Hello, @Arya Could you please retest using the same formula that @thomask shared? Because whenever there is a null value, I always use the same formula. PFB the snaps from my analysis. [image] Thanks & Regards Biswajit Dash

Thank you @thomask . I have been using your solution to get around the problem.

Formatting empty value cell in pivots

Q&A

Hassain April 20, 2023, 11:44am 7

Hey @Bchadha,

Do we have any update on the feature ?

Filling missing value with 0 in pivot table

Topic		Replies	Views
How to replace blank to 0 in pivot table? Q&A quick-sight , pivot-table , Business-Intelligence-Engineer , 한국어	3	199	July 17, 2025
Displaying “0” in Pivot table instead of blanks Q&A analysis , formatting , quick-sight , pivot-table , Business-Intelligence-Engineer	2	4998	August 26, 2025
Include a default value to Pivot Table cellls Q&A quick-sight	10	632	June 2, 2023
Fill Empity space with zero Q&A formulas , quick-sight , visuals , calculations , pivot-table , Business-Intelligence-Engineer	10	118	May 9, 2025
How to show 0 instead of blank in pivot table where records does not exist Q&A formatting , feature-request , quick-sight	2	838	May 16, 2023

Formatting empty value cell in pivots

Related topics