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 MOTORC...
whitch
Resolver I
Resolver IImagine 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).