Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
It needs to be done in the query model. Go to Edit Queries -> Transform -> Transpose
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
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.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |