Horizontal list of values in Report Builder paginated report

[mbowler]

I have built a paginated report in Report Builder that implements pick up routes for recycling collections. It's based on tabular data like this:

Type	Day	Week	Street	Property
Card	Tuesday	1	Bee Hall Crescent	9
Card	Tuesday	1	Bee Hall Crescent	43
Card	Tuesday	1	Carrow Road	6
Card	Tuesday	1	Gilmoreton Way	15
Card	Tuesday	1	Gilmoreton Way	19
Card	Tuesday	1	Gilson Crescent	1
Card	Tuesday	1	Hall Lane	16
Card	Tuesday	1	Hall Lane	58
---	---	---	---	---
Glass	Wednesday	2	Blacklock Road	33
Glass	Wednesday	2	Blacklock Road	35
Glass	Wednesday	2	Colliers Reach	11
Glass	Wednesday	2	Eglinton Street	28
---	---	---	---	---

I've used two List components, one embeded inside the other to get the route title and then the list of streets and property numbers:

However I have only managed to list the property numbers in a table object:

But the customer would actually prefer the property numbers to be a horizontal list like this:

Does anyone know how I can achieve this? TIA

[mbowler · Accepted solution]

I have managed to solve this by updating the query on the dataset so that the property field is being concatenated as I summarize the table data e.g.

        SUMMARIZECOLUMNS(

            'Table'[Type],

            'Table'[Day],

            'Table'[Week],

            'Table'[Street],

            "PropertyList", CONCATENATEX('Table', 'Table'[Property], ", ", 'Table'[Property])

        )

Then I just replaced the table with a text box that has the PropertyList field in it.

Note: The second 'Table'[Property] in the CONCATENATEX statement is to make sure the concatenation is sorted, I initially left this out and was getting the property numbers in a random order.

[v-jtian-msft]

Hi,@mbowler .I am glad to help you.

After my test, I tried to group Street and Property, but the test is similar to your result, for different Propoerty under the same Street, after grouping, the system will divide it into two rows. Instead of displaying them side by side in one row.

The reason for this is that your setup requires the list to create a RowGroup, but requires the data to be presented locally as a columnGroup.

You may want to try using a matrix to create the grouping in the matrix.
The matrix allows you to group data in rows and columns for more flexible presentation of data

You can also try to modify your original data to combine all the Propoerty under the same Street into one row (change the data in the data source).

I hope the links below will help you
Merge cells in a data region in a Power BI paginated report - Power BI | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.