Forum Discussion
Display Zero Data Points on Line Chart after Merging Date Table and Data Table to Forecast
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.
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])+03. Put date from date table on X axis
measure on Y axis :Result:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
4 Replies
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])+03. Put date from date table on X axis
measure on Y axis :Result:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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:
