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.
Hi this is school related. I have attendance data that comes in weeks column by column.
example below. The first column is the student, the following columns are the weeks showing the percentage of attendance for that week.
student | week 1 | week 2 | week 3 |
a | 99 | 56 | 99 |
b | 99 | 89 | 99 |
c | 97 | 99 | 100 |
I want a line graph or bar chart it to show week as the X and percentage as the Y. The year groups will be the legend showing the average attendance of each year group per week. I havew this data linked in off another table.
I'm working in the idea i need to change the layout as follows
week | student | attendance |
1 | a | 99 |
1 | b | 98 |
1 | c | 78 |
2 | a | 98 |
2 | b | 90 |
2 | c | 89 |
3 | a | 100 |
I can't change how it comes out of the database/MIS. I need to change it in BI
Solved! Go to Solution.
@jblackburnHWGA , Unpivot week columns in power query
https://radacad.com/pivot-and-unpivot-with-power-bi
That was quick. I couldn't figure out what i was looking for. I didn't know you could pivot select columns. Something new learnt
@jblackburnHWGA , Unpivot week columns in power query
https://radacad.com/pivot-and-unpivot-with-power-bi
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 |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |