DAX measure to show zeros in Line Graph

[Anonymous]

There has to be a simple solution to this, how do I continue the orange line to show 0's?

This graph is showing the # of Items and the # of items who have a QTY greater than 1. 

The line graph is a measure to calcuate the total QTY if the QTY is greater than 1.

How do I get it to show the zeros? Ex: the line for feb should not break, it should continue to the bottom and then back up for March.

My measure is this:

MEASURE = CALCULATE(SUM('Table'[QTY]), 'Table'[QTY]>1)

I read that all I have to do is add +0 at the end. THIS DOES NOT WORK. This is what happens:

It technically works, but adds a junk in the front and the back and completly ignores the date filter I have set up.

OH and people are like just change the graph type to continous to linear. Well, that does not show up as an option for me in my X-Axis. wish i could, but can't

THIS SHOULD BE SO SIMPLE. my measure is simple. Why is this so hard? I have probably tried to figure this out for atleast 12 hours. Help PLEASE.

[AlB]

Hi @Anonymous 

Can you share the pbix, or a simplified version that reproduces the problem? 

[parry2k · Accepted solution]

@Anonymous try updaing your measure like this

MEASURE = 
(CALCULATE(SUM('Table'[QTY]), 'Table'[QTY]>1) + 0 ) *
DIVIDE( [Total # of Items], [Total # of Items] )

Assuming you have [Total # of Items] measure in your model that you are using for bar

[Anonymous]

@parry2k  You a lifesaver - I knew it had to be something simple like that. THANK YOU!