Visualization of 5 different tables comparing data over time range

[mkim]

I have basic knowledge of Power BI and am looking for help with a new project. I have an excel workbook wtih 5 different tabs showing enrollment data for schools in 5 tabs, a tab showing a different year (2012, 2013, 2014, 2015 and 2016). Each school has their own row. The columns in each tab are all the same. Columns include school name, district name, school code, enrollment numbers, school type.

My goal is to create one visualization comparing a school's enrollment numbers over the 5 years. What's the best way to show all 5 table data into one visualization? Mainly looking at trends over the years.

[MattAllington · Accepted solution]

You should load all the data into a single table in power BI. Everything will be easier thereafter. 

i wrote an article how to do this here https://exceleratorbi.com.au/combine-all-sheets-in-a-workbook-with-power-query/