Data Studio: how to remove null values from reports

How to remove null in Data Studio?

‍Sometimes in Data Studio (formerly Looker Studio), some metrics displays Null in a charts instead of a zero. But this can be avoid and you can choose what to display between a range of choice.

We will cover it in this article.

‍Missing data configuration:

‍Every charts has a configuration for the missing data. It is called Missing data and is located in the Style section. To access it, follow these steps:

• Go to the Style column and locate the Missing data section.
• Click on the dropdown and select a value. You can choose between:
  • "no data"
  • "0"
  • "-"
  • "null"
  • " " (blank)

Adapt it to your situation and remember that you can edit it at once for several charts.