Below video shows how to calculate the moving average or the rolling average and build informative rich tooltips in Power BI. When you highlight events on a line chart with time-series data, providing a moving average gives a clear indication of the trend on a chart. You will also learn some useful DAX techniques in building the solution.
This is part two of the two-part video series. In the first video, you can learn how to highlight events on a chart timeline using DAX and conditional formatting.
You can find the part one video HERE
Hope this article/video was helpful to you? Please leave your comments, suggestions or questions in the comments.
Fowmy Abdulmuttalib is a Microsoft-certified business intelligence professional with extensive experience in finance, accounting and data analytics. Currently, he is employed by McDonald’s Saudi Arabia as the Head of ERP and Business Intelligence. He is interested in everything data-related, he likes to share his passion and knowledge with the data community.
Pingback: Part 1 – Learn how to HIGHLIGHT events on Power BI chart TIMELINE – ExcelFort