format table visualization: transpose

Question

I created a table visualization in Power BI, and it contains all the information I want. I just wish I can transpose it to make the format look better. Is there a way to achieve this?&nbsp;For example my table looks like:&nbsp;_______ &nbsp; &nbsp; &nbsp;subject1 &nbsp; &nbsp; &nbsp; subject2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;subject2student1 &nbsp; &nbsp;grade1_1 &nbsp; &nbsp; grade1_2 &nbsp; &nbsp; &nbsp; &nbsp; grade1_3student2 &nbsp; &nbsp;grade2_1 &nbsp; &nbsp; grade2_2 &nbsp; &nbsp; &nbsp; &nbsp; grade2_3&nbsp;what I want is:__________ &nbsp; student1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; student2subject1 &nbsp; &nbsp; grade1_1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;grade2_1subject2 &nbsp; &nbsp; grade1_2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;grade2_2&nbsp;&nbsp;thank you.

bryanst · Answer

I had a similar issue and did a google search and looked at some of the responses.

In the end I stumbled across the Format option under Values "Show on Rows", which was set to Off as default. Switched that and the format switched. No addtional code.

roseventura · Answer

Genius!&nbsp; That's exactly what I needed!&nbsp;Thank you!

anonymous · Answer

Thank you.This been bugging me for a while. Glad I found this post.&nbsp;To add to this, the option found when using&nbsp;'Matrix' in Visualizations, in format (paint roller).&nbsp;

dallassalazar · Answer

Jesse,&nbsp;&nbsp;If you highlight the data you'd like to swap [for instance, it appears you want to swap the positioning of the top rows for the side columns --- which is a pretty common need]:&nbsp;&nbsp;1) simply highlight your data that you'd like to "swap" or move2) copy the data or use CTRL+C3) instead of trying to "paste" the data into the "swap" position [i.e. using CTRL+V] - click the "paste" BUTTON in the top left side of Excel4) click the "transpose" button --- to which I've highlighted within the RED CIRCLE&nbsp;Your data should pre-fill in vertical format [i.e. column] instead of horizontal [i.e. row].&nbsp;&nbsp;I hope this was what you were looking for.&nbsp;-Dallas&nbsp;

jessiewulala · Answer

Thanks Dallas, but I cannot do this in Power BI. Sorry I didn't montion it is a Power BI task in my previous question.

Forum Discussion

format table visualization: transpose

9 Replies

Related content

Help Transposing

Formatting Matrix Visuals

Formatting Visual Calculations

Transpose data in table visual

Transpose data