I have been trying to use / replace null with 0 but that’s not working. Have tried all the ways round, I can’t do it in the dataset, so is it possible to fix it please. Sample screenshot attached.
Also please introduce union via 2 different data sources in the quicksight.
Today, the setting only affects presentation of fields that are placed into Rows and Columns. It is not used if field is placed into Values field well.
At the moment, if you want to see zeros instead of empty cells in the table or pivot table values, you need to change the expression to return zero. This might even require changing the dataset if the data is sparse.
I expect QuickSight team to provide more options when configuring tables so that you can customize the value if it is not present however this work has not been prioritized yet. (This work impacts not only the presentation of the data but the calculations as well. When you want to show 0 for missing rows, it should impact totals and subtotals calculations. For example, average of [0,1,2] is different from the average of [1,2]. )