Forum Discussion
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:
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?
I have solved the issue, by creating a custom visual using charticulator
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
7 Replies
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
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
