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 ; Value1

Value2 ; Value2 ;Value2 ; Value 2

To :

Title 1 ; Value1 ; Value2

Title 2 ; Value1 ; Value2

Title 3 ; Value1 ; Value2

Title 4 ; Value1 ; Value2

I have checked in power BI without success , please let me know if there is any solution to this .

Thanks in advance

Ismail

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

5 Replies

jmelcarek
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