Including more than one dataset (6) in a graph

[fpetersen]

I need to make a graph about the evolution of the amount of students enrolled in a higher education institution and I have 6 different datasets: one for each year from 2011 to 2016.

(Each year, each student gets a unique code and then I use the count function to get the quantity of students per year.)

[TomMartens · Accepted solution]

Hey,

I would highly recommend to create one table from your source files. You can use the function "Append Queries" from the "Combine" ribbon in "Home" menu in the Query Editor.

I guess you have to determine some kind of business rule that a student can be uniquely identified across all the years.

This document also provides some guidance about tidy data, even if it's not directly related to Power BI, it's also valid for Power BI:

https://www.jstatsoft.org/article/view/v059i10/v59i10.pdf

Regards

Tom