I created a video to demonstrate how you can 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 can impact sales performance. You can apply these techniques to any similar scenario.
This is part one of the two-part video series. In the second video, we will learn how to create a dynamic moving average and tooltip to further enhance the value of this Power BI report
⏬ You may download the completed Part-1 PBIX file HERE
Published 5 years ago
Version 1.0Fowmy
Super User
I’m a Microsoft-certified BI professional with a solid background in finance, accounting, and data analytics. My main focus is on Power BI and Microsoft Fabric development, where I work on building BI solutions, consulting, and corporate training. I enjoy helping others develop their skills in data analytics and stay active in community forums to keep up with the latest trends and best practices in the field.Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news.
If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.