Forum Discussion
Grouping data in different columns
I have a set of data which looks like the below:
| Order Number | Amount 1 | Amount 2 | Amount 3 | Amount 4 |
| 1 | 138 | null | null | null |
| 1 | null | 124 | null | null |
| 2 | null | null | 127 | null |
| 2 | null | null | null | 130 |
| 3 | 144 | null | null | null |
When I display this in a table in PowerBi it looks like this;
| Order Number | Amount 1 | Amount 2 | Amount 3 | Amount 4 |
| 1 | 138 | null | null | null |
| 1 | null | 124 | null | null |
| 2 | null | null | 127 | null |
| 2 | null | null | null | 130 |
| 3 | 144 | null | null | null |
However I really want to have the amount associated with each order number, i..e I want it to be displayed like this:
| Order Number | Amount 1 | Amount 2 | Amount 3 | Amount 4 |
| 1 | 138 | 124 | null | null |
| 2 | null | null | 127 | 130 |
How can I do this? I want to display this data in my actual report.
6 Replies
- Pragati11
Super User
Hi Anonymous ,
Add summarisation of SUM on all of your AMOUNT columns.
Thanks,
Pragati
- amitchandak
Anonymous , Check all these four column should be of number type -Amount 1 Amount 2 Amount 3 Amount 4
Ande set their default summarization as the sum
- Icey
Community Support
Hi Anonymous ,
I can't reproduce your issue. Please share us your pbix file. Please remove sensitive information. It is suggested to upload your file to OneDrive for Business and then paste the link here.
Best Regards,
Icey
