Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
TBaldwin11
Frequent Visitor

Help with Grouping Data for Table

Hello All,

 

I am trying to put together a data table for one of our managers in Power BI with the goal of having 1 line per Order. Data currently has mutliple lines. I can do the Group Rows function and get the Part Name and Qty into 1 cell, but it tend to come out looking like a blob ( AAA - 1BBB - 3CCC- 5) rather than seperating into even lines. The Part Names and Qty vary in length significantly so there is no formating that I have figured out. Any suggestions on how to get the Part Names on seperate lines in the same cell?

 

Current

Order#Part NameQty
111111AAA1
111111BBB3
111111CCC5
222222BBB4
222222AAA2
222222DDD1
222222FFF4
333333BBB1
333333AAA1

 

Ideal

Order#Part Name - Qty
111111AAA - 1
BBB - 3
CCC - 5
222222BBB - 4
AAA - 2
DDD - 1
FFF - 4
333333BBB - 1
AAA- 1
1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @TBaldwin11 

 

You can try the following methods.
Column:

Part Name-Qty = [Part Name]&"-"&[Qty]

vzhangti_0-1686551872973.png

vzhangti_2-1686551898185.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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

2 REPLIES 2
v-zhangti
Community Support
Community Support

Hi, @TBaldwin11 

 

You can try the following methods.
Column:

Part Name-Qty = [Part Name]&"-"&[Qty]

vzhangti_0-1686551872973.png

vzhangti_2-1686551898185.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@TBaldwin11 , Use Matrix Visual, Stepped Layout - off

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.