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

Carlos Jahir Carreno Hernandez 0 Reputation points
2023-11-29T21:01:04.3666667+00:00

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.

enter image description here

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

enter image description here

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,783 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. RAHUL KASBE 0 Reputation points
    2023-11-30T01:08:11.7633333+00:00

    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.

    Unpivot Example

    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

    0 comments No comments

  2. Emi Zhang-MSFT 23,811 Reputation points Microsoft Vendor
    2023-11-30T01:11:52.8666667+00:00

    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.

    0 comments No comments