Forum Discussion

bvdm1980's avatar
bvdm1980
Helper II
3 years ago

How to get a solid line chart when data is missing

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!

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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