Forum Discussion
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 measures) with it's corressponding value. There will only be 1 value per attribute.
4 Replies
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
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...
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
Hi v-danhe-msft,
Thank you for your response, I am looking for the same functonality than vickyd. Your solution could work but it involve create a whole new query for one visual. Is there a way to create a one dimension table visual horizontally and not vertically ?
Regards,
Vi
