Forum Discussion
Summarize Data into Pie Chart but from Different Columns
Hi,
I need to summarize data into a pie chart with the following table
| ID | First Transport Qty | First Transport | Second Transport Qty | Second Transport |
| 1 | 1 | TRUCK | 7 | CAR |
| 2 | 3 | MOTORCYCLE | ||
| 3 | 1 | CAR | 2 | TRUCK |
| 4 | 5 | BICYCLE | 3 | MOTORCYCLE |
| 5 | 2 | TRUCK | 2 | TRUCK |
I need to have a Pie Chart that displays the total split % or volume such as :
TRUCK - 7
CAR - 8
BICYCLE - 5
MOTORCYCLE - 6
The problem is that I have 2000 rows and can only pull out the "First Transport" column only, I can't include the "Second Transport" column.
How can I create a pie chart that shows all of the data labels with their combined values?
Thanks
1 Reply
whitchResolver I
Imagine how much easier this would be if your data was structured like this:
Qty Transport Type 1 TRUCK First 3 MOTORCYCLE First 1 CAR First 5 BICYCLE First 2 TRUCK First 7 CAR Second 0 null Second 2 TRUCK Second 3 MOTORCYCLE Second 2 TRUCK Second Can you make it like this in Power Query? You'll probably want to duplicate your current table, have one copy just for firsts, the other for seconds, then apppend together to get a result like the above (you can disable data-load for the intermediary tables).