Forum Discussion

mcameron2909's avatar
mcameron2909
Frequent Visitor
4 years ago
Solved

Create new rows from pivot columns retaining category and value fields

Hi all,   I have a requirement where we are importing list data from Sharepoint that has employee names as columns and this needs to be transformed to row values in our Power BI model to enable fil...
Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    Just select your Category and Skill columns, right click and choose "Unpivot Other Columns" to get your result.

     

    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Just select your Category and Skill columns, right click and choose "Unpivot Other Columns" to get your result.

 

Pat

 

  • mcameron2909's avatar
    mcameron2909
    Frequent Visitor
    4 years ago

    Thanks so much Pat, basic functionality that I've missed! Works as expected, cheers.