Forum Discussion

vickyd's avatar
vickyd
Helper V
8 years ago

Horizontal 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...
Need Help
vickyd's avatar
vickyd
Helper V
8 years ago
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's avatar
    v-danhe-msft
    Microsoft Employee
    8 years ago

    Hi 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