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
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 Name | Qty |
111111 | AAA | 1 |
111111 | BBB | 3 |
111111 | CCC | 5 |
222222 | BBB | 4 |
222222 | AAA | 2 |
222222 | DDD | 1 |
222222 | FFF | 4 |
333333 | BBB | 1 |
333333 | AAA | 1 |
Ideal
Order# | Part Name - Qty |
111111 | AAA - 1 BBB - 3 CCC - 5 |
222222 | BBB - 4 AAA - 2 DDD - 1 FFF - 4 |
333333 | BBB - 1 AAA- 1 |
Solved! Go to Solution.
Hi, @TBaldwin11
You can try the following methods.
Column:
Part Name-Qty = [Part Name]&"-"&[Qty]
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.
Hi, @TBaldwin11
You can try the following methods.
Column:
Part Name-Qty = [Part Name]&"-"&[Qty]
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.
@TBaldwin11 , Use Matrix Visual, Stepped Layout - off
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
91 | |
84 | |
76 | |
64 |
User | Count |
---|---|
136 | |
113 | |
104 | |
98 | |
92 |