selecting multiple rows and combine them into single row in power BI desktop

[roniedhaka]

Dear all- i need your kind help [ i am new in PBI dekstop]. or please direct me the solution link.

i have an massive excel file and i imported into power BI dekstop. Now instead doing it in excel [dont know which is more convenient], i want to combine multiple rows of below table [example below country 'b to e' into single row 'other' with combine data also [order/sales'margin].  how to perform?

[v-piga-msft · Accepted solution]

Hi @roniedhaka ,

For your requirement, it should be easy to achieved in Power BI with creating the group.

You could click the More options beside the country column and then select New group.

Then you could create the table like below.

More details, please refer to my attachment.

Hope this can help you!

Best Regards,

Cherry

[TomMartens]

Hey,

what is the business rule that determines which countries are binned to the "group" other.

Maybe it's just as simple as to create a new column "group" and for country "a" assign the value "a" and for all other countries assign the value "other".

If it's not that easy as I assume, can you describe the underlying business rule, provide sample data (either pbix or xlsx) that reflects your data model, upload the file to onedrive or dropbox and share the link.

Regards,

Tom

[roniedhaka]

thanks for your reply.

Actually there is no specific 'business rule'. I want to combine selected rows into a single row.

Column headers can be 'country' or 'products' or 'city' or anything- but values are always same order/sales/margin.

The 'other' showed above screenshot- i chose to make an example- nothing else.  One month certain countries are pinned into 'other'- perhaps next month new group of countries. All i want to know- how to comibine multiple rows [selection choices are mine] in to single row with column header 'other' and values order/sales/margin are also arithmatic SUM.  thanks.