AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
3K members online now
3K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Line chart shows zero for future dates

Participant ✭ ✭ ☆
# 1
Participant ✭ ✭ ☆

I have a line chart that maps a metric by month with a breakdown dimension by year. This means that for 2017, the line has values for January and February, but then drops to zero. I'd like for the line to just stop at the February value, rather than dropping to zero for March (and later). How can I do this?

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Litmon
February 2017

Re: Line chart shows zero for future dates

Explorer ✭ ☆ ☆
# 2
Explorer ✭ ☆ ☆

It sounds like you're using a Time Series chart, so if that's the case you can set "Missing Data" to use "Line Breaks", like this:

 

 Screen Shot 2017-02-03 at 3.20.09 PM.png

 

You can access that setting by clicking on the chart and choosing "Style" group of settings (top-right of page).

 

Does that fix the issue for you?

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Litmon
February 2017

Re: Line chart shows zero for future dates

Explorer ✭ ☆ ☆
# 2
Explorer ✭ ☆ ☆

It sounds like you're using a Time Series chart, so if that's the case you can set "Missing Data" to use "Line Breaks", like this:

 

 Screen Shot 2017-02-03 at 3.20.09 PM.png

 

You can access that setting by clicking on the chart and choosing "Style" group of settings (top-right of page).

 

Does that fix the issue for you?

Line chart shows zero for future dates

Participant ✭ ✭ ☆
# 3
Participant ✭ ✭ ☆

Perfect, thank you!