How to get a solid line chart when data is missing

[bvdm1980]

Hi

We have multiple projects for which we have to fill in a monthly forecast result. Some projects miss some months with data. 

When i use a line chart for each project individually, it shows a nice line, as it only reflects the months with data in it. But ofcourse when i use a line chart for my 5 projects combined, i get gaps in the lines. Shown in printscreen

So what is the solution to fill those gaps and get a solid line if i have a combined chart? We dont have that data, its not gonna be filled backwards. 

Can that be solved with some dax work? 

thanks for the help again!

[Anonymous]

HI @bvdm1980,

You can write a measure formula to replace original value field that you used on chart and add an if statement to check if current date does not have correspond values. Then you can write calculate formulas to look up the previous nonblank results to replace current blank result.

If you are confused about coding formula, can you please share some more detailed information and dummy data to help us clarify your scenario and test?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng