Day-by-day data on line graph displayed as infinite.

[mformagnificent]

I want to display a line graph that shows the usage for every month and year, but I also want the user to drill in for any one month in particular and see the day-by-day trend of the daily usage.

When I include days, my data displays as infinite (2E+308). I would like it to show clearly the day-to-day patterns. I made sure that only one item and one location site was filtered. 

When I include days

When I only do Month and Year. It displays fine (even though the data is not right, but that I can try to fix myself).

Why does this happened and how can I fix this so that I can see the day-by-day trend?  

*As mentioned in my comment below: 

Maybe there's a formula where I can avoid infinities. I think the reason why infinity is shown is that there are some values that are 0.

0 divided by a number is infinity. 

This is the formula for daily usage: 

Daily Usg = [QtyTotal]/([DateDuration] * (5/7))

What formula/measure can I use to avoid this?

However I don't see any Qty Total data displayed as 0. I just want my line graph to show the correct data for day-to-day

[mformagnificent · Accepted solution]

Ok I resolved it. 

instead of using this formula:

Daily Usg = [QtyTotal]/([DateDuration] * (5/7))

I used this. Now I don't see infinite values

Dailyusg = DIVIDE([QtyTotal],[DateDuration 2] * (5/7))

[mformagnificent]

Maybe there's a formula where I can avoid infinities. I think the reason why infinity is shown is that there are some values that are 0.

0 divided by a number is infinity. 

This is the formula for daily usage: 

Daily Usg = [QtyTotal]/([DateDuration] * (5/7))

What formula/measure can I use to avoid this?

However I don't see any Qty Total data displayed as 0. I just want my line graph to show the correct data for day-to-day