How to transform rows in columns in a table with measures?

[CSpina]

Hi, guys!

I have a table where the measures are columns and I need to transform in rows:

THe config is:

I need the following table:

Any ideas?

[v-yiruan-msft · Accepted solution]

Hi @CSpina ,

You can follow the below steps to achieve it:

1. Unpivot columns in Power Query Editor

• Select column EMP AUT, EMP CAM, EMP COM, EMP MOT, EMP ONI, EMPL SER and EMPL TRAT
• Navigate to Transform ribbon, click Unpivot columns and choose "Unpivot Only Selected Columns" optionUnpivot Only Selected Columns

2. Create a matrix(Rows: Attribute   Columns: Coluna   Values: Value)Best Regards

Rena

[Anand24]

@CSpina,

You can you Matrix visualization but you will need to re-structure(pivot current table) your table a bit.

Below image shows the table changes(left side of image) and final output viz(right side of image) with config:

Don't forget to give thumbs up and accept this as a solution if it helped you !!!

[simrantuli]

Hi @CSpina ,

Try Matrix.

Best Regards

Simran Tuli

[amitchandak]

@CSpina , In matrix, you have an option show on the row

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

or

Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/