Nest the rest of the columns under the first column in Power BI.

Question

In a query I performed, it resulted in a Power BI table displaying all the information in columns. Now, I need to set the first column as the primary one, and the others should belong to that column as shown in the image.

The result I want is to transform the information from the first image to the second image, as there are many columns.

Answer 1

Hi Carlos ,

In this scenario you can perform unpivot column transformation in power query to transform data.

Select all “item” columns only and apply unpivot column transformation.

Tried to replicate scenario, Hope this will help.

Reference the Microsoft Learn for details:  https://learn.microsoft.com/en-us/power-query/unpivot-column

Do let me know if you have any queries.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics

Answer 2

Hi,

I suggest you post this issue to Power BI forum:

https://community.fabric.microsoft.com/t5/Forums/ct-p/PBI_Comm_Forums

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.