Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
avanroij
Helper I
Helper I

Line chart combined with scatter

I would like to create a line chart combined with scatter in Power BI.

A requirement is that the scatter serie may contain the same xaxis values, but I want to see all the values (so use the not summarize option, like available in a scatter chart. 

 

 

Basically I want to combine the 2 (line and scatter) charts in 1 chart: 

sctter.jpg

I used this dataset: 

data.jpg

the problem is that i want to use the not summarize option, which is not available in de combined charts. 

 

I have tried the standard visuals, also did some experimenting with R, but to no avail 

anyone knows how to do this?

 

2 ACCEPTED SOLUTIONS
avanroij
Helper I
Helper I

I have solved the issue, by creating a custom visual using charticulator

View solution in original post

I used Charticulator (https://charticulator.com/app/index.html) to combine a scatter segment with several line segments, like this:

avanroij_1-1649795438631.png

 

note: now you can use the charticulator integration in power bi desktop (charticulator is a custom visual) .  

Good luck

View solution in original post

7 REPLIES 7
avanroij
Helper I
Helper I

I have solved the issue, by creating a custom visual using charticulator

I would like to know how you did as I have tried and failed to achieve

I would like to reach such a result

davidRodriguez1_0-1649779455718.pngdavidRodriguez1_1-1649779569469.png

I used Charticulator (https://charticulator.com/app/index.html) to combine a scatter segment with several line segments, like this:

avanroij_1-1649795438631.png

 

note: now you can use the charticulator integration in power bi desktop (charticulator is a custom visual) .  

Good luck

Could you please go into a little more detail on how you did this?

 

I am trying for a similar result, a line chart that would behave like a scatter chart in that it would let me show raw data without aggregation on any axis.

I am stuck right now, with Charticulator not letting me to use the "Do not summarize" option. Do you have any suggestions for how to get this done?

Thanks in advance!

Pragati11
Super User
Super User

Hi @avanroij ,

 

Did you try looking into adding lines to a scatter chart visual?

https://community.powerbi.com/t5/Desktop/Draw-lines-in-scatter-chart/td-p/644624

 

There is also a custom visual called Spline Chart. Try checking it:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380860?src=office&tab=Overview

 

Let me know if these help.

 

Thanks,

Pragati

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

@Pragati11 , thanks for the reply.

The scatter datapoints are not a trend or spline, the values are not related to the other values. the scatter datapoints are a separate serie. 

I can't use analytics to add a serie and can't use the spline.

 

any other suggestions? 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.