Search code examples
matrixpowerbireportssrs-2008

Create reports - Matrix with text without aggregation


I need to create the following report, the idea is that students will attend to all classes but in any day, the report needs to group who attend to what in a specific day, I'm using power BI report builder, but it's not workingreport example table example


Solution

  • Closest I got in about 5 minutes was this:

    Measure: Student List = CONCATENATEX('Schedule',[Student],UNICHAR(10) & UNICHAR(13))

    Matrix with Class on Rows, Day on Columns (you'd need to create separate table of days to force them to sort by the day of the week.), and [Student List] on Values.