Show zero when there is no data in line chart

[Capstone]

I have the following line and stacked column chart. Effective Duration in green and work order count in black are both measures. For days when there is no duration data there is no bar displayed (as I wanted). But for days when there is no work order data I want the line chart to display zero (basically the yellow line instead of the black line). Can Power BI achieve this ? My axis is continuous and I want it that way and not categorical.

[v-jiascu-msft]

Hi @Capstone,

Can you mark the proper answer as a solution please?

Best Regards,

Dale

[Floriankx]

Maybe you can try however the black line is calculated to replace empty values by 0.

IF(ISBLANK([Value]),0,[Value].

Or you try something like

SUMX(DateTable,Related(Table[Value]))