Erik Svensen builds a dynamic moving average:
With the introduction of visual calculation in the February 2024 release of Power BI desktop (https://powerbi.microsoft.com/en-us/blog/visual-calculations-preview/) – this gives us some new possibilities to add calculations on the individual visual and some new functions gives us some exiciting options.
One example could be to use the MOVINGAVERAGE function (link) to and combine it with numeric range parameter to make it dynamic.
Click through for a video and a description of how to do it.