Forum Discussion

Stu_22's avatar
Stu_22
New Member
4 years ago
Solved

Change layout of data from data source

Hello,  I'm fairly new to Power BI and struggling with an Excel data source that isn't laid out in the format I require. I'm using Power BI Desktop and have had a play around with the Edit Queries...
Need Help
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Stu_22 ,

     

    In Power Query, select your [Inspection] column, then go to Transform tab > Unpivot Columns (dropdown) > Unpivot Other Columns.

     

    This should do what you want.

     

    Pete

Stu_22's avatar
Stu_22
New Member
4 years ago

Thanks very much Pete - that's worked a treat!

 

Regards,

 

Stuart