Transpose operations in Power BI - Step-by-Step Guide

Introduction

Transpose operations let you switch rows and columns in your data table. This helps when your data layout is not suitable for analysis or visualization and you want to flip it to a better format.

When your data has dates as rows but you want them as columns for easier comparison.

When you receive data where categories are in columns but you need them as rows to create charts.

When you want to swap the axis of a table to better fit your report layout.

When you want to fix data imported from Excel that has headers in rows instead of columns.

When you want to prepare data for a matrix visual that requires a different orientation.

Steps

Step 1: Open

- Power Query Editor

The data preview window shows your current table with rows and columns.

Step 2: Select

- Transform tab in Power Query Editor

The ribbon shows available transformation options.

Step 3: Click

- Transform tab > Transpose button

The table flips so that rows become columns and columns become rows.

Step 4: Review

- Data preview in Power Query Editor

You see the transposed table with the new orientation.

Step 5: Click

- Home tab > Close & Apply

The transposed data loads into Power BI for use in reports.

Before vs After

Before

Table has 5 columns: Product, Jan, Feb, Mar, Apr with sales data in rows.

After

Table has 5 rows: Product, Jan, Feb, Mar, Apr with sales data in columns.

Settings Reference

Transpose

📍 Power Query Editor > Transform tab

Switch rows and columns in the data table.

Default: No transpose applied

Common Mistakes

Trying to transpose data directly in the report view.

Power BI does not support transpose in report view; it must be done in Power Query Editor.

Open Power Query Editor and use the Transpose button under the Transform tab.

Not checking headers after transpose.

Headers may become data rows or vice versa, causing confusion.

After transpose, use 'Use First Row as Headers' option if needed to fix headers.

Summary

Transpose operations flip rows and columns in your data table.

Use Power Query Editor's Transform tab to apply transpose.

Always check and fix headers after transposing to keep data clear.