how to display multiple values in a cell in a paginated report

[mr_wizard]

I have the following dataset table:

I have a paginated report, created in Power BI Report Builder.  I want to display the following on the report using the dataset table above:

How can I achieve this?  In particular, how can I make a cell display multiple values?

[Anonymous]

Hi, @mr_wizard 

I've tried using the matrix in Report Builder and I'm not able to do the same as what you illustrate in the picture. But you can try to use the custom table in Report Builder, enter the first column one by one, and then use the expression in the second column to determine whether the label of the current first column is teams, if so, then take out the teams corresponding to the blob, the third column, the fourth column is similar.

=IIf(Fields!Empolyee.Value = "Bob" , Fields!Teams.Value,First(Fields!NewColumn0.Value, "DataSet2"))

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mr_wizard]

@Anonymous 

Can you please explain what you mean by "enter the first column one by one"?  In particular, how did you get the data value for Employee to appear in a column to the right of the Employee header?