Forum Discussion
Find changes in trend
In statistics, a moving average is the most frequently used way to identify trends with smoothing out short-term fluctuations. With PBI, it's even more informative by visulizing it.
i_like_tacos - You don't really need to implement any complicated DAX for this. You could do so with the right choice of visualisation. Customising a Scatter Plot would help visualise changes to the norm for each student.
This is a great article that will show you how: https://www.sqlbi.com/articles/using-scatterplots-to-find-details-in-reports/
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!
Thank you both. I've been able to implement the moving average window into my project and have been successful getting it to work. I am playing with it to try to expand functionality across other KPIs I'm working with.
The scatterplot method proposed is an interesting take and I am also playing with that and seeing how that may be incorporated as well.
Many Thanks!
i_like_tacos - I think Scatter plots are often the best visualisation for spotting outliers.