Forum Discussion
Solved
Summary table with slicer support
Hi All, I'm hoping someone will be able to help the following. In a simplified form, have a table which lists a number of StudentID's alongside several columns stating which group the ID is a me...
Hi Damondo
You may try to use 'Unpivot columns' as below.Then you may get the table.Attached sample file for your reference.
Regards,
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi Damondo
You may try to use 'Unpivot columns' as below.Then you may get the table.Attached sample file for your reference.
Regards,
Thanks so much v-cherch-msft, this is exactly what I need. On my file I've created a copy of the main student table with reduced columns then run an unpivot on there. 120k rows but not a problem for Power BI! One extra thing I had to do with the relationship between the StudentID's was to set the Cross Filter to 'Both'. That way, I could put measures from the student table into the unpivot table visual.
