Forum Discussion

JohannTTG's avatar
JohannTTG
Icon for Helper I rankHelper I
3 years ago
Solved

Line chart - connection of dots when data is missing

Hi, I use a line chart for different series of values (legend-setting is used) When for some series a specific values is not available then the line is broken. From a pure technical point of view t...
  • barritown's avatar
    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

    My YouTube vlog in English

    My YouTube vlog in Russian