Missing Data in Google Data Studio

This option controls how to display missing values according to your preference. For example, when data is missing from the scorecard, you can choose to show blanks (""), 0 (Zero), hyphens (-), the words "null" or "No data."

Missing Data in Google Data Studio
Missing Data in Google Data Studio

  1. [Missing Data] — options include "null", 0, hyphens (-), "No data", and Blank ("") for following charts

    • Scorecards

    • Table

    • Pivot Table

    • Gauge Chart

  2. [Missing Data] — for time series charts, three options include "Line to zero" (Default Option), "Line breaks", and "Linear Interpolation"

    • Time Series

    • Area

Enjoy reading the guide? I have explained every chart available in the new Data Studio Book here. Visual explanations for graphs configurations, style, format, and recommendations. So you can also see how the final result will look and why one design is better than others for the same chart.