Dynamic Variance Analysis with Power BI - Different Forecast Versions Comparison

When I was first started my journey with Power BI, I always struggled to create visualization for showing the variances between different budget/forecast versions. Things are always done manually in Excel as I'm only able to total up the different versions and manually substract them in a spreadsheet. I'm able to find videos and tutorials about actuals comparing against budget and previous years, but not something about comparing different forecast versions and where you can change dynamically After some research and self-studying, I am finally able to create a dashboard specifically for comparing different forecast versions against one another dynamically with Power BI. In this video, I will share the steps to setup your data model from scratch so that you can achieve similar outcome with Power BI and you can compare all the different forecast versions you have in the archive easily. 00:00 Introduction 00:17 Data Model Example 01:30 Step 1 - Create an index table containing all unique forecast versions 02:48 Step 2 - Create a copy of forecast versions table to be used as the comparison 03:08 Step 3 - Create slicers for users selection 04:13 Step 4 - Create all measures required to calculate variances and using matrix visual for data validation 06:17 Setup Bar Chart to visualize variance 07:07 Setup Waterfall Chart to visualize variance 07:35 Setup Line Chart for trend analysis and visualization 08:22 Trailer for future videos - Comparison against multiple versions all in a single table 08:34 Thank you and see you!! PBIX file used in the video: https://drive.google.com/file/d/1EXSp23Tre2zFQOYRI-pcHEiF7I1cPs9n/view?usp=sharing MY FAVOURITE GEAR 💻 My Personal Laptop, Legion 5 Pro - https://amzn.to/3nZrn1I ✈️ My Travel Companion, Macbook Air M1 - https://amzn.to/43jLLuE 📷 My Camera Gear, Sony ZV-E10 - https://amzn.to/40T7uIj Disclaimer: Do note that this is the way I built my data model and it is by no means the only way or the most efficient way to do it. If you have better and more efficient way to achieve the outcome, feel free to comment and let me know about it. #PowerBI #VarianceAnalysis #ComparisonReport #DynamicVarianceAnalysis #Variance Analysis 🤝 BE MY FRIEND: 🐦 Twitter - https://twitter.com/JoelTing92 🏢 Linkedin - https://www.linkedin.com/in/joel-ting/ 🙎🏻‍♂️ WHO AM I: I'm Joel, an analyst working in Singapore. I make videos about technology, automation and productivity. 📧 GET IN TOUCH: If you'd like to talk, I would love to hear from you. Email me directly at [email protected] would be the quickest way to get a response. I will try my best to reply to your email as soon as possible.