Forum Discussion
Helper VHorizontal Table
Microsoft EmployeeHi vickyd,
Based on my test, you can refer to follow steps in Query Editor:
1.Demote your headers by using “Use Headers as First Row” function.
2.Transpose your table and you can see the result you want.
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/bqh753dgn3v9jgj/Horizontal%20Table.pbix?dl=0
Regards,
Daniel He
Helper V
v-danhe-msft wrote:Hi vickyd,
Based on my test, you can refer to follow steps in Query Editor:
1.Demote your headers by using “Use Headers as First Row” function.
2.Transpose your table and you can see the result you want.
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/bqh753dgn3v9jgj/Horizontal%20Table.pbix?dl=0
Regards,
Daniel He
Apologies for not being clear. I am looking at how to display it on the report and not within Power Query.
Something along these lines...