Forum Discussion
vickyd
Helper V
Helper VHorizontal Table
Is there any way I can show a horizontal table with columns names on the left and values on the right? I basically want to show a list of employee attributes (just dimensional attributes not meas...
vickydHelper V
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...
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi vickyd,
Based on my test, I am afraid you can not transpose your columns in the report. I suggest you to display it in Query Editor and I am appreciate it if you could tell me why you don't want to use Query Editor.
Regards,
Daniel He