Line chart blank values +0 not working

[BoringName]

Hiya,

I'm having trouble with a line chart refusing to show values as zero instead of blanks. I know many people on here have had similar issues, but none of the solutions seem to work on this one so I'd be super grateful if anyone can suss it out!

I've created some dummy data but can't upload the pbix file so please let me know if you need any additional info.

month	id	perm_temp	newstarter
Jan-22	id01	perm
Jan-22	id02	temp
Jan-22	id03	perm	new to org
Feb-22	id01	perm
Feb-22	id02	temp
Feb-22	id03	perm
Feb-22	id04	temp	new to dep
Mar-22	id01	perm
Mar-22	id02	temp
Mar-22	id03	perm
Mar-22	id04	temp
Apr-22	id01	perm
Apr-22	id02	temp
Apr-22	id03	perm
Apr-22	id04	temp
Apr-22	id05	perm	new to org
Apr-22	id06	temp	new to org
Apr-22	id07	perm	new to dep
May-22	id01	perm
May-22	id02	temp
May-22	id03	perm
May-22	id04	temp
May-22	id05	perm
May-22	id06	temp
May-22	id07	perm

*note that the empty cells in newstarter are null

I created a measure 'Starters' to plot the chart (as you can see, I already tried a number of variations and had a couple still commented out in there):

Starters =

VAR Result = count('Table'[newstarter])

//return Result

return Result+0

//return if(Result = blank(), 0, Result)

//https://community.powerbi.com/t5/Desktop/show-items-with-no-data-as-0-instead-of-blanks/td-p/113160

//return if(max('Table'[newstarter]) in values('Table'[newstarter]) , Result+0, blank())

//https://community.powerbi.com/t5/Desktop/Show-zero-instead-of-blank-but-maintain-filters/m-p/1596868

What I want (sorry I forgot to erase the '(Blank)' line, but I should be able to just filter that out after anyway):

What I get ("return Result" vs. "return Result+0"):

On a side note, weirdly it works when using perm_temp as the legend instead, I imagine it's something to do with the nulls in the newstarter field but don't understand why ("return Result" vs. "return Result+0"):

(side, side note, I unintentially made the 'perm/temp' breakdown look the same as the 'new to org/dep' breakdown)

Thanks in advance!

[Priya1969]

For removing blank values, in the below link, I explained in step by step.

https://community.powerbi.com/t5/Desktop/Matrix-Table-Visual-Breakdown-Drilldown-by-Column/m-p/30156...

[BoringName]

Thanks, however I need to keep the blank values for some of the other stuff. Someone else sorted it with using a separate date table though so all good. Cheers

[amitchandak · Accepted solution]

@BoringName , Prefer to have a separate date table , and they try +0 and this option

[BoringName]

Legend, thank you!