Make line of graph go to zero

[SamfarUK]

Hi everyone! First time poster here 🙂  

I really need help with this column/line graph please? I want the line y-axis to actually go down to 0.00% rather than just disappear. 

I can't figure it out and I can't seem to find a resolution either. 

[mussaenda]

Hi @SamfarUK ,

Have you tried adding +0 on your measure of line graph?

[SamfarUK · Accepted solution]

I was about to ask you where/how I would add this but thought I would give it a go myself... 

I have now added that +0 to the end of the measure and it has worked perfectly, thank you!! 

[BITomS]

Hi @SamfarUK 

This might help you: https://stackoverflow.com/questions/55495656/show-0-value-on-line-chart-in-power-bi-for-missing-data....

It looks like you need to force the use of a zero in your measure.

[SamfarUK]

Thanks for your response!

I did see multiple times online about changing the type, but I genuinely can't see where to do this; these are my options:

(FYI - I am using the Power BI Desktop on my laptop) 

[BITomS]

I think the part about how to express a measure is more pertinent:

Measure = IF(ISBLANK([MeasureName]),0,[MeasureName])

[SamfarUK]

Do I need to add the measure somewhere specific?

Also, the dataset doesn't have any blanks and is not showing null:

Not sure if this measure works? 

[BITomS]

Please could you share your data model? (pbix file)