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 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.