Concatenate column values to single row in visualization

Question

I have this table in Power BI, where the visible rows all have the same tracking number, but there are multiple rows due to the sku column.

How can I achieve a result like this where this is shown in just one row, and all skus are listed comma separated:

I have achieved this using pandas, but want to do the same in Power BI. However, I have not been able to find a solution to this issue.

Marcus · Accepted Answer · 2022-12-06 12:31:29Z

4

You need to use CONCATENATEX evaluating the list of SKU for that row in your visualization. You measure will need to look something like this:

skus =
CONCATENATEX (
    VALUES ( 'Table'[sku] ), 
    [sku],
    ","
)

answered Dec 6, 2022 at 12:31

Marcus

4,0251 gold badge7 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Instead of using VALUES( 'Table'[quantity] ) use CONCATENATEX ( 'Table' , 'Table'[Quantity] , ", " )