Display Zero in Visual Not "No Data"

Question & Answer
1

Hey
I have a KPI filter that is based on rows returned - Now sometimes this returns 0 rows
Rather than 'NO data" is there a way I can show it visually as 0, please?

1 Like
2

Hi,

Thanks for reaching out. I just built a test example of this where I have dimension values in one table and fact rows in a separate table, which I think may be your situation. When I do that, I’m able to get this to work. If I switch between the underlying field and the “value” field it flips from “No data” to showing 0. If your data is structured differently you may need a different solution.

ifelse(isNull(Value),0,Value)

Best,
Sean

3

Hi, @scottEh. Did @SeanBoon’s solution work 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!