Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

Transpose table titles from columns to rows

Hello , I need to transpose a power BI table , please see the example below : change title position from this : Title1 ; Title 2 ; Title 3 ; Title 4 Value1 ; Value1 ; Value1 ...

Anonymous
8 years ago
Hi

In Query Editor,

1. Go to Transform -> select option 'Use Header as first row'. So, for your example you will have 3 rows now ,with Title1..Title4 as first row
2. Then select Transpose. This will get you desired output with 3 columns & 4 rows. Name the column header as needed.

Thanks
Raj

Regular Visitor

8 years ago

It needs to be done in the query model. Go to Edit Queries -> Transform -> Transpose

Anonymous
Not applicable
8 years ago
Hello Jmelcarek ,

Thanks for the reply , unfortunatey I did not get the correct result , is there any power query that we can use to resolve this issue ?

Thanks in advance
Ismail
- Weav8060
  Frequent Visitor
  5 years ago
  correct, it does work with tables, only with sheets prior to promoting headers. With table inputs, use this trick formula just prior to transposing step:
  = Table.Combine({ #table(Table.ColumnNames(Source),{Table.ColumnNames(Source)}),Source})
  it creates a first row of your data set with the column names . There might very well be another way, but transpose functionality is geared to the rows of the table not including column names
Anonymous
Not applicable
8 years ago
Hi

In Query Editor,

1. Go to Transform -> select option 'Use Header as first row'. So, for your example you will have 3 rows now ,with Title1..Title4 as first row
2. Then select Transpose. This will get you desired output with 3 columns & 4 rows. Name the column header as needed.

Thanks
Raj
- rlsmith1994
  Helper II
  3 years ago
  This solution doesn't make sense. The person just wants to transpose the visualization. Transposing the rows/columns in the editor will change the structure of the data.

Related content