Forum Discussion
Joining lines in line chart
Hi all 🙂 I'm trying to create a visual where 2 seperate lines join. Currently im at the following stage: We can see the blue line does not connect to the red line. The lines are ba...
Try creating a measure with the sum of both columns (or sum the measures if you have them):
Full line = SUM(Table[Column 1] + SUM(Table[Column 2])
Create a measure for the blue line (or use the corresponding measure):
Blue Line = SUM(Table[Column1])
add both measures to the line visual (Blue line measure on top in the values bucket)
lbendlin
Super User
Super UserYou cannot do this in DAX measures. You will need to add the two missing data points in Power Query or a calculated table and append them to the original data.
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.