Display Zero Data Points on Line Chart after Merging Date Table and Data Table to Forecast

[TylerVono]

Hello Power BI Community,

Kinda stumped on this one. Do you know a good way to displaying data points with value 'zero' (job order)s to the dataset to make sure they appear on a line chart?

Here I have a Many to One Relationship with the Date Table, after I merged the two Tables as NEW (Completed Jobs Table & Date Table) = Completed Jobs Forecast New (Merge)

Currently My Line Chart is only graphing a Value of 1 as bottom, I would like it to graph 0. Otherwise, it doesnt really show the fluctuation of graphing data.

Do you know any tricks to add zero job orders for missing periods? 

As you can see there is no option to fill in any 'null value', as I have days gap /missing dates where I would like to just have 0 recorded jobs.

[Ritaf1983 · Accepted solution]

Hi @TylerVono 
The steps to create the line with 0 are :
1. Change the relationship to single from both :

2. Add 0 to your measure .
For example :

totalValue = sum('Table'[Value])+0

3. Put date from date table on X axis
measure on Y axis :

Result:

Link to a sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[TylerVono]

Hi @Ritaf1983 ,

Thank you for your help!

I believe it works, however my only other ask is that if possible can the Line Y axis still record "0" rather than stop? I'd like to just show the line continous decline resting at zero.

An example of what it shows:

An example of what I would like it to show:

[Ritaf1983]

Hi @TylerVono 

Yep. In the same way.

[TylerVono]

Thats odd, it does not work, keep in mind I did a left outer join date table merge, so I am using the the actual Job completion date as my X-Axis. Any other ideas perhaps?

X-Axis: Scheduled Completion Date (Bins) - Month

Y Axis: Count of Job Order as new Column: Job Order plus 0 = 'Completed Jobs Forecast New (Merge)'[job_order] + 0

Line Y-Axis:  Job Order plus 0 = 'Completed Jobs Forecast New (Merge)'[job_order] + 0 - Count.

Here is another example:

Pretty much just want it to look like the red dashes: