The line graph has gaps over time. fil gaps in a line graph. reportbuilder 3.0

Question

I have a graphic graph over time. Data is grouped by week. For several weeks I have no data, which creates spaces in the line. Now I would like to associate spaces. I found the ability to insert empty dots into the graph for missing data. But, as I understand it, this requires a certain color. But the graph should be dynamic and automatically use the color of the graphs.

Help would be greatly appreciated

Answer 1

You must make sure that the hart type is a continuous linear type so that the line does not stop and starts with gaps.

Empty and null data points in charts

Edit:

There is also a recommended formula that you should use in this case for RB 3.0.

Empty points (1) or Empty points (2)