Transpose Data in Power BI

A-Badde | Posted on April 06, 20

 If you have a query with data in columns that you need to rotate to rearrange it in rows, you can use the Transpose feature.

 The Transpose feature switchs data from columns to rows, or vice versa. if your data looks like this:

 It will rearrange the table to this:


Here’s how to do it using the Power Query Editor:

   1.  Open the Power Query Editor then the data set that you want to transpose. The picture below shows the query before the transposition

   2.  To transpose the data table, select Transpose from the Transform Tab

After selecting Transpose, the data moves from rows to columns.

   3.  Rename and change the data type of columns.

The transpose feature eliminates the existing column headers and replaces it with the default (Column1, Column2….). We can rename them and change their type to get the final result

It only remains to close and apply, then use the transpose data to draw your insights.


Related Video:



(0) Comments

There is no comment

Leave a Comment
Add to favorite
Recent Posts
DAX Language - CONTAINS Function
A-Badde | May 09, 20

The CONTAINS function returns a boolean value, TRUE if each ...Read More

DAX Language - RANKX Function
A-Badde | May 05, 20

The RANKX function returns a single integer value that repre...Read More

DAX Language - AND and OR Functions
A-Badde | April 10, 20

AND/OR functions check whether all arguments are TRUE or one...Read More

DAX Language - Variables in DAX
A-Badde | April 10, 20

Use Var keyword to store the result of an expression as a na...Read More