Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
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
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
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
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!
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
@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?
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |