Assessment Data - Basic Line Graph

[loepan]

Hey Everyone,

I've exported assessment data from standardized tests and would like to make a basic line graph in PowerBI using the data. Below are two examples with the IDs changed and student names removed. One image is of a test given in the Spring of 2017 and the other is for the Spring of 2018. I've tried to change the Term to a date, May 1, 2017, for example, but was also unsuccessful.

I can easily make these data dashboards in Excel using the same data, but am unable to understand how to do so in PowerBI.

I'd appreciate some guidance on where to put the data (Axis, Value, etc) and if any relationships are needed besides ID.

Thanks in advance for your assistance.

[v-eqin-msft · Accepted solution]

Hi @loepan ,

According to my understanding, you want to use a line chart to display these two tables,right?

Since the structure (column names) of the two tables are the same,you could easily use UNION() to combine them like this:

Table = UNION('2016-2017 Table','2017-2018 Table')

Then you could create visualizations directly:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.