Forum Discussion
Scatter Plot with a Rolling Average Line in Power BI
- 1 year ago
Hi Anonymous ,
You can use a Line and Scatter Chart (or Combo Chart) to overlay:
Scatter plot of raw X vs Y values
Line plot of average Y per X-binHere are few Steps to Implement:
Create Bins for X-Axis (In your case bins are already created).Right-click your X-axis field - New Group
Choose Bin Type: Number of Bins (e.g., 10)
Create a Measure for Average Y per Bin:AvgY_PerBin = AVERAGE('Table'[Y])
Create a Line and Scatter Chart or Combo chart:
X-Axis: X (for scatter) and X_bin (for line)
Y-Axis:
Raw values: Y (scatter)
AvgY_PerBinIf this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
Hi Anonymous ,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.