in this video, you will learn how to highlight any time bound events on a chart timeline using DAX and conditional formatting in Power BI. In addition, in this example, we will analyze and visualize how events like Covid lockdown, promotions, and campaigns impact sales performance. Once you learn these techniques , you can apply them on any similar scenarios.
This is the part one of the two-part video series. In the second video, we will learn how to create a dynamic moving average and an informative tooltip with KPI to further enhance the value of this Power BI report.
You can find the part two 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-2 How to HIGHLIGHT events, MOVING AVERAGE & build rich TOOLTIPS in Power BI – ExcelFort