The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Power BI offers an Analytics lines for a line chart. i can see things like Min line, Max line, Average line, Median line, etc. But what i would like is a moving average line. Meaning each point on the x-axis I would like an average of all the points that i have ploted on the x-axis point. i have a weekly line chart, with a legend with a dozen or so differnt lines and i want to chart a weekly average line for each week but i don't see that offered. Any solutions for this?
Please refer to this thread:
https://community.powerbi.com/t5/Desktop/Create-a-rolling-average-metric-by-Week/m-p/278050
User | Count |
---|---|
5 | |
5 | |
2 | |
2 | |
2 |
User | Count |
---|---|
10 | |
7 | |
4 | |
4 | |
4 |