Power BI: Adding Historical Data to Existing Dashboard in Power BI - Staff Engagement Report Part-II

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.
#PowerBI #Dashboarding #DataAnalysis #TimeSeries #Slicers #LineCharts #HistoricalData #Trends #Tutorial #HowTo

[@virtual_school]

Part One: ua-cam.com/video/R3E95SD7kZA/v-deo.html
Link to the Excel and Power BI files: drive.google.com/file/d/1zW8Bqe76Atl4-B0UzaVGhCOEU_AKed6E/view?usp=sharing

[@patriciaejindu]

This is great. Very clear and guided tutorial which was easy to understand. I tried following along but couldn't get the line chart to quite work. In addition to the main page showing everything overall, what would be the correct steps to create a visual page for each region so that it shows that region and its corresponding units?

[@virtual_school]

Line chart is simple. You just put values on one axis and period on the other axis.

[@patriciaejindu]

@@virtual_school I did but for some reason line is just straight not curved.

[@virtual_school]

Oh. check the field, does it show count or sum? It should be sum.