Forum Discussion
Line chart - connection of dots when data is missing
- 3 years ago
Hi,
While I was checking your issue Power BI somehow made this line with the gap continuous, but I am not sure how it happened so just be aware of that.
There is a workaround however - you add one more sequence to your line chart, exactly like the one with the gap, but where the gap is filled with a value - ( Jan + Mar ) / 2, for example. You remove the markers for the continuous line and change its color to the same color that is assigned to the line with the gap.
Best Regards,
Alexander
Hi,
While I was checking your issue Power BI somehow made this line with the gap continuous, but I am not sure how it happened so just be aware of that.
There is a workaround however - you add one more sequence to your line chart, exactly like the one with the gap, but where the gap is filled with a value - ( Jan + Mar ) / 2, for example. You remove the markers for the continuous line and change its color to the same color that is assigned to the line with the gap.
Best Regards,
Alexander