cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Majad_Chowdhury
Frequent Visitor

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:

 

Majad_Chowdhury_0-1635341565591.png

We can see the blue line does not connect to the red line.

 

The lines are based off the values in the following table:

Majad_Chowdhury_1-1635341624331.png

Ideally I think i'd need to take the value from "MaxRawNegativeNew" for the 08/04/21 and replicate it in the "MaxRawPositiveNew" column in the corresponding date. 

 

I'm just not sure how to achieve this, from the research I've done thus far I'm guessign it involves "FIRSTNONBLANK" but my knowledge of implementing this is limited.

 

Thanks in advance wizards!

1 ACCEPTED SOLUTION
PaulDBrown
Super User
Super User

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)





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

3 REPLIES 3
V-lianl-msft
Community Support
Community Support

Hi @Majad_Chowdhury ,

 

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)))

Vlianlmsft_0-1635833131434.png

 

 

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

PaulDBrown
Super User
Super User

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)





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






lbendlin
Super User
Super User

You 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.

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!