This video demonstrates a few powerful techniques to highlight values or data points that are above or below average in a chart, going beyond the built-in reference line functionality in Power BI. Learn how you can apply conditional formatting in a line chart with a simple tweak, and finally, I will build a dynamic average calculation using DAX to work in different levels of a date hierarchy.
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.