Connect Line Chart Line

[DevBI99]

Hello there,I have this dashboard and I want to investigate for an issue that relates to Line Chart according to the below photo:

The lines charts are seems seperated from each others, and I want to tie them together as you see the bottem left lines and the top right lines. The tie for each one of them color per color.

Thanks,

[Anand24 · Accepted solution]

Hi @DevBI99 ,
Those disconnected lines are due to the value being blank/null for those X-Axis category values. 
You will need to convert those blanks/nulls to 0 so that the lines get connected.

Here's a sample DAX for new calculated measure:

New_Value1 = IF(ISBLANK(SUM('Table'[Value1])), 0, SUM('Table'[Value1]))

Here's the result (Bottom Line chart is with new values😞

[rajendraongole1]

Hi @DevBI99 - can you please share the same with dummy data?

By structuring your data correctly and using the Line Chart visualization in Power BI, you can achieve continuous lines of the same color.