Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
74 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |