Forum Discussion

pipkinp86's avatar
pipkinp86
Regular Visitor
3 years ago
Solved

Report Builder - 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 b...
PowerBIReportServer
reportbuilder
  • pipkinp86's avatar
    pipkinp86
    3 years ago

    this is how I ended up fdoing it:

     

    EVALUATE

    (

        SUMMARIZE(

          'Schedule',

            'Schedule'[day],

            'Schedule'[class],

            "StudentList", CONCATENATEX(VALUES('Schedule'[Student]), 'Schedule'[Student],", " & UNICHAR(10))

        )

    )

d_gosbell's avatar
d_gosbell
Super User
3 years ago
pipkinp86 wrote:

But I don't know how to make it work on Report Builder

 

The identical approach should also work in Report Builder. If you use the [Class] and [Day] columns and the [Student List] measure you should be able to create a similar matrix output to the one you did in Power BI desktop.

pipkinp86's avatar
pipkinp86
Regular Visitor
3 years ago

Hello, I was not able to use the measure within a matrix in Power BI report builder, I found another way to make it work, adding the measure withing the query, but if you can give me more details on how to use the first Power BI desktop approach, using the measure I created on power bi desktop, I would appreciate it.