Display 0 instead of "No Data" in a KPI Field

I have a KPI widget that shows a numeric field (with a few filters). How do I make it to show “0” instead of “New Data” ?

Hi Karthik,

hope you are doing good.

You can do it by using the conditional formatting.

Step one


Step two Set 0 if found null .

Naveed Ali

hi @Naveed Thank you for the quick response. In my case, this is a custom field that is set to 1 (always) and the “No data” in the KPI is because after I add 3 filter conditions, there are no records that match those filters and hence “No data”. How do I fix this. ?

@Karthik1 Hmm not sure if we are able to display a 0 in that case since after you apply your filters there are no rows left to even substitute a 0 into. If I think of any ideas Ill post them here, but as of right now I dont think it’s possible.

1 Like

Hi, @Karthik1
Was @Jesse’s answer good enough for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!

Hi @Karthik1 , you can do this using this function, “coalesce(sum({Your Measure field}), 0)”!

1 Like