Forum Discussion

Jaweed's avatar
Jaweed
Helper III
5 years ago
Solved

Assistance ( Reposted - wrong location)

Hi everybody   How to transform a table in PowerBi 2 hours ago Hi everybody Can Anybody assist me? I have a table in Power Bi that I uploded. Typical records are as below. Company       C...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, Jaweed 

    You can try the following steps:

    Sample:

    Step1:Transpose column in Query Editor

    Step2:Use First Row as Headers

    Step3:Merge columns

    Step4：User Headers as First Row and Transpose columns

    Step5:Duplicate columns and split columns

    Result:

    Finally, to change the name of the first column to what you want.

     

     

    Is this the result you want? Hope this is useful to you

    Please feel free to let me know If you have further questions

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng

daxer-almighty's avatar
daxer-almighty
Solution Sage
5 years ago

Jaweed 

 

Why would you like to do it? The format you're trying to get the data into is not correct for reports in PBI. It's, of course, easily obtained through Power Query but why the heck would you want to do it? You can easily get the matrix visual to display data like this... The column Col-combined can be obtained easily through a measure as well.