Show x-axis values when no y-axis value is available

[Anonymous]

I have a data set similar to the one below. I would like to show date in the x-axis and event1 in the y-axis. As you see, there is not a event1 value for each date value, but I would like to see them all, event if no data is available. See screenshots below for clarification. 

I need to do this when the variable in the x-axis is both categorical and continuous. Can you please provide solutions for both? 

Thanks a lot

[AnthonyTilley · Accepted solution]

create a new measure and use an if statment to replace blanks with zeros

Event1Line = 
var ev1 = sum('Table'[Event1])
var ret = if(ev1 = BLANK(),0,ev1)
return ret

top line is using just to event1 colunm the second is a new line using the measure above