Forum Discussion
Transforming Data - Headers to Rows & Rows to Headers
Good morning,
Just recently started working with Power BI and was asked to build the charts on the right (image below) from the data on the left. Essentially converting values for the PERIOD field into columns and then grouping/pivoting(?) off of each of the other fields. Is this possible? Assuming i have to transpose but I haven't gotten close yet. Any insight would be greatly appreciated. Thanks
Hi dee80bee ,
Unpiovt columns
Then put the Attributes in the Rows of matrix table. Looks like this:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi dee80bee ,
Unpiovt columns
Then put the Attributes in the Rows of matrix table. Looks like this:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.