Forum Discussion
Anonymous
4 years agoNot applicable
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...
- 4 years ago
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)
PaulDBrown
Community Champion
4 years agoTry 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)