Line chart combined with scatter

[avanroij]

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: 

I used this dataset: 

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?

[avanroij · Accepted solution]

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

[avanroij · Accepted solution]

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

[Syndicate_Admin]

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

[Syndicate_Admin]

I would like to reach such a result

[avanroij · Accepted solution]

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

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

Good luck

[o_w]

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]

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

[avanroij]

@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?