Series Smoothed Line Chart

[MyEthiopia]

Hi All, 

Is it possible to remove just 0 labels from my line chart that is based on time/date. I want to total count label to be visible but remove 0's from the chart as well as the same between the different peaks. 

[AdrianWelsh]

What happens if you do a filter for those values (where the value does not equal 0)? Does it truncate your chart in a way that does not look good?

[MyEthiopia]

Thanks @AdrianWelsh No change unfortunately, is it because it's a date field? 

[AdrianWelsh]

Possibly so. Can you change the value of the 0 to a null value, therefore nothing should show up?

[MyEthiopia]

Did that nothing changed. To explain further the 0 values don't exist within the data, that's where I am having trouble filtering it out.

[AdrianWelsh]

Hmm, maybe I am not understanding the data very well. I notice that if I try this with some data that I have, it shows me a 'count' of all points that occurred on those dates. This is how it looks natively (similar to yours, except it shows a '1' instead of a 0).

But if  I choose Parse Dates, it looks a little more spread out

Maybe that could work in yours?

[MyEthiopia]

I am using hour instead of day. And my data is aggregated using data expression. Instead of the manually populated date/time field (there was a date formatting issue). I am using the creation date field.

[MyEthiopia]

@AdrianWelsh Thank you for troubleshooting with me. My end users didn't complain but I would love to see it cleaned up.