cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
roniedhaka
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
v-piga-msft Resident Rockstar
Resident Rockstar

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.

View solution in original post

3 REPLIES 3
Super User III
Super User III

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 your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!
roniedhaka
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.

v-piga-msft Resident Rockstar
Resident Rockstar

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.

View solution in original post

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors