Forum Discussion
Scatter Plot Average Line
Looking at your chart, it seems odd that your X-axis is a count of UIDs. It seems that how many UID's a certain product category has isn't a useful way to group or plot them. However, it seems your problem resides in how simple and uncustomizable the Data Analytics lines are for scatterplots.
I've done some reasearch, and playing around with your example file, and as far as I can tell, there's no way accomplish this with a scatterplot, unless you make a custom visual. I even played around with some of the scatterplots on the marketplace, and none of them seemed to be able to accomplish this either.
My solution would be to use a different visual. I'd set this up as a bar and line chart. Then you can set up a measure or your average column as the line value, and set the category types as the X-Axis.
up
still no solution around?
i face the same problem not having the option to have a weight calculation when average on group of record
this will be major PITA for my project with Powerbi if no workaround.
i need to do a lot bubble chart at group level with a weighted average (which allow to show which group perform better than the average)