Forum Discussion
Solved
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 ...
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.
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.