Amazon QuickSight now supports ‘Missing Data’ control for both line and area charts. Previously, line charts only supported ‘missing data’ treatment for datetime fields. Now, we have added support for categorical data as well for both line and area charts. Instead of displaying broken lines (default behavior), Authors can also choose to display broken lines as either continuous lines by directly connecting to the next available data point in series or interpolate these missing values with zero and display a continuous lines. More details can be found here.
This is a companion discussion topic for the original entry at https://aws.amazon.com/about-aws/whats-new/2022/09/amazon-quicksight-adds-missing-data-control-line-area-charts/