Part-1 📊 Learn how to HIGHLIGHT events on Power BI chart TIMELINE

This video shows how you can highlight or show 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, campaigns etc., 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, also called the rolling 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: https://www.youtube.com/watch?v=3VajEecHMSs ⏲ Video Timestamps 00:00 - Intro 00:26 - Looking at the data model and the initial report. 02:10 - Building the 1st Measure to highlight events on the chart. 05:30 - Apply Conditional formatting highlight events on the chart, 06:36 - Build the 2nd measure to calculate the overall average daily sales, 08:31 - Build the 3rd measure to calculate the event average daily sales, 12:33 - Build the 4th measure to calculate the % change of the above two measures, 15:50 - Closing ⏬ You may download the completed Part-1 PBIX file here: https://excelfort.com/part-1-%f0%9f%93%8a-learn-how-to-highlight-events-on-power-bi-chart-timeline/ 👨‍🏫 For Instructor-led virtual training programs, visit: https://excelfort.com/training/ or 📧 [email protected] 🟢 LET'S CONNECT! ------------------------------------------------------ -- http://facebook.com/excelfort -- https://twitter.com/excelfort -- https://linkedin.com/in/fowmy #excelfort