Forum Discussion
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 builder, but it's not working. I did was able to make it work on Power BI using
Measure: Student List = CONCATENATEX('Schedule',[Student],UNICHAR(10) )
Matrix with Class on Rows, Day on Columns and [Student List] on Values.
But I don't know how to make it work on Report Builder
Below is the data table and what I wanted to look like
this is how I ended up fdoing it:
EVALUATE
(
SUMMARIZE(
'Schedule',
'Schedule'[day],
'Schedule'[class],
"StudentList", CONCATENATEX(VALUES('Schedule'[Student]), 'Schedule'[Student],", " & UNICHAR(10))
)
)
3 Replies
this is how I ended up fdoing it:
EVALUATE
(
SUMMARIZE(
'Schedule',
'Schedule'[day],
'Schedule'[class],
"StudentList", CONCATENATEX(VALUES('Schedule'[Student]), 'Schedule'[Student],", " & UNICHAR(10))
)
)
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.
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.
