cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
roniedhaka Frequent Visitor
Frequent Visitor

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

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?

 

 

1.jpg

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

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.

group.PNG

Then you could create the table like below.

Capture.PNG

More details, please refer to my attachment.

Hope this can help you!

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Super User
Super User

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

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

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
roniedhaka Frequent Visitor
Frequent Visitor

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

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.

Community Support Team
Community Support Team

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

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.

group.PNG

Then you could create the table like below.

Capture.PNG

More details, please refer to my attachment.

Hope this can help you!

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.