Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    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)

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

Create two measures and add the date filter conditions.

Set the type of x-axis  to categorical.

Measure = CALCULATE(MAX(financials[ Sales]),FILTER(financials,financials[Date]<>DATE(2014,4,1)&&financials[Date]<>DATE(2014,5,1)))
Measure 2 = CALCULATE(MAX(financials[ Sales]),FILTER(financials,financials[Date]=DATE(2014,4,1)||financials[Date]=DATE(2014,5,1)))

 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.