University > Looker Studio Course > How to > How to remove null in looker studio ?

How to remove null in looker studio ?

How to remove null in looker studio ?

How to remove null in looker studio ?

‍Sometimes in 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)

Change null value for 0 or a blank space in Looker Studio.

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

More function to use with Looker Studio

:

Understanding and Utilizing the REPLACE Function in Looker Studio for Clear, Concise, and Accurate Data Insights

:

Unlocking the Power of the TODATE Function in Looker Studio: A Complete Guide

:

Unleashing the Power of the WEEKDAY Function in Looker Studio: A Comprehensive Guide to Data Analysis Based on Weekdays

:

Mastering the MEDIAN Function in Looker Studio: A Comprehensive Guide to Syntax, Use Cases, and Limitations

:

Exploring the Versatility of the EXTRACT Function in Looker Studio: A Comprehensive Guide on its Syntax, Application, & Limitations

Become a Looker Studio expert
for free

Learn all the secrets of data analysis and create beautiful and effective dashboards thanks to our 30-second video courses! Join Catchr's community on YouTube.

Get more video lessons

All your data on Looker Studio

Build Looker Studio dashboard easily with your marketing data from all platforms and track your essential KPIs! No-code integration.

Start free trial now!

Looker studio

Optimize your data analysis

Get free Looker Studio dashboard template among a large collection of +50 stunning template! Elevate your data visualization.

Get free templates!

Johan Chemin

Customer Success Manager & Looker Studio Expert

I design powerful dashboards that enable you to effectively analyze your marketing data. I also provide comprehensive lessons on mastering your BI tools. Feel free to contact me for assistance with these areas.