Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |