This video tutorial shows how to include historical data into an existing dashboard that only has data for one period. It explains how to add a new year column to the data, incorporate it into the Power BI queries, and use slicers to view data for specific years. The video also covers how to create a line chart to visualize trends over time.
Part One:
https://youtu.be/R3E95SD7kZA
Link to the Excel and Power BI files:
https://drive.google.com/file/d/1zW8Bqe76Atl4-B0UzaVGhCOEU_AKed6E/view?usp=sharing
#PowerBI #Dashboarding #DataAnalysis #TimeSeries #Slicers #LineCharts #HistoricalData #Trends #Tutorial #HowTo