Forum Discussion
Multiple column from single column
Hi Friends,
I have a requirement,
Input Table:
| Source | Active | Participants | Total % | Assets | |
| A | 1 | 121 | 70443 | 4 | |
| B | 3 | 222 | 22 | 3 | |
| C | 4 | 555 | 3 | 8 | |
| D | 2 | 888 | 19587 | 1 | |
| E | 0 | 987 | 6962 | 2 |
This is the input data I have from a single table.
Output Data:
| A Active | Aparticipants | Atotal% | Aassets | Bactive | Bparticpants | Btotal% | Bassets | Cactive | Cparticpants | Ctotal% | Cassets | So On...... |
| 1 | 121 | 70443 | 4 | 3 | 222 | 22 | 3 | 4 | 555 | 3 | 8 |
This is the output need to acheive. All data is coming from single table.
Apart from that few other coulmn will aslo get inserted in the output table.
Please let me know how to bring this requirement.
2 Replies
Hi LearnPowerBIAS ，
Here I suggest you to try to create a matrix visual.
For reference: Create a matrix visual in Power BI - Power BI | Microsoft Learn
Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have someother feilds as well as input. With Matrix it is not possible.
Source Active Participants Total % Assets Parent Child A 1 121 70443 4 AAA A12 B 3 222 22 3 BBB B23 C 4 555 3 8 CC C12 D 2 888 19587 1 DDD D98 E 0 987 6962 2 EE E45
