Forum Discussion
Power BI Tricky new question
Dear community,
Below is what is visual in my power Bi dashboard
| Parent Cost Type | Plan Total | MLO | Actual USD Constant |
| PTW | 73506.22259 | 73506 | 17098 |
| People Cost | 68571.10653 | 68571 | 30362 |
| SLSL | 30184.64045 | 30185 | 11717 |
| Other | 0 | 0 | 79 |
| Sold Time | -5261.96957 | -5262 | -2986 |
i would like to achieve below
| Parent Cost Type | PTW | People Cost | SLSL | Other | Sold Time |
| Plan Total | 73506.22259 | 68571.107 | 30184.64 | 0 | -5261.97 |
| MLO | 73506 | 68571 | 30185 | 0 | -5262 |
| Actual USD Constant | 17098 | 30362 | 11717 | 79 | -2986 |
let me know how can i achieve this?
5 Replies
That greatly depends on what your original source data looks like, how is that structured? Is it like the first table?
Try to follow the below steps
Demote to header as rowTransposeAfter TransposePromote first row as header
