Forum Discussion
bvdm1980
Helper II
Helper IIHow 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 ...
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