Cummulative Line charts

[Sudhavi_84]

Hi Experts,

I have a measure where it does cummulative measure correctly and shows in chart accurately.

But what I am facing issue is, example few projects has no value like not even zeros, they have blank.. with this cummulative line is breaking.

for Example Jan, Feb , Mar, May, July has values and cumulative showing even if it has Zero.

but for April and Jun projects has blank with this cumulative line is not appearing for April and June. how can we resolve this issue please..

Please see image below orange line breaks because of having blank for that particular month. Should I include in measure something? because measure is just summing up on monthly basis..

[Sudhavi_84]

Sorry guys, I didn't try it yet. Will try this week and will update you. Thank you very much for you help.

[v-henryk-mstf]

Hi @Sudhavi_84 ,

I think @selimovd  response was helpful. If the question has been resolved, please mark the correct response as the standard answer to help the other members find it more quickly.

If not, please point it out. I will answer you as soon as possible.

Best Regards,
Henry

[selimovd · Accepted solution]

Hey @Sudhavi_84 ,

are you using a proper date table?

When you are using a date table and put the date from there in the graphic, the blanks should usually not cause a gap as the date exists. 

Here is a small tutorial how to create a date table:

https://softcrylic.com/blogs/power-bi-for-beginners-how-to-create-a-date-table-in-power-bi/

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Sudhavi_84]

Thanks @selimovd