Power BI convert rows to columns

Question

I have a table in Power BI that has the following structure:

| Product Name | Quantity Sold 
---------------------------------------------
| iPhone 13 | 100 
| Samsung Galaxy S22 | 50 
| Google Pixel 6 | 25 

I want to convert this table so that the product names are in the columns and the quantity sold are in the rows. How can I do this in Power BI?

Answer 1

How to convert rows to columns in Power BI?

Converting rows to columns in Power BI, also known as pivoting, is a common data transformation process that involves reorganizing data to make it more structured and easier to analyze.
This operation is particularly useful when you have data in a tabular format and want to present it in a different layout for reporting or visualization purposes.

How to Pivot Columns in Power BI?

Steps:

To convert rows to columns in Power BI, you have to do the following:

1. In Power BI Desktop, Click on "Transform Data" to open "Query Editor".
   
2. In Power Query Editor, select the columns that you want to pivot. These are the rows you want to convert into columns.
3. Click on the "Transform" tab in the Power Query Editor ribbon.
4. Click on the "Pivot Column" option.
   
5. A dialog box will appear, In the Pivot Column dialog, select the column whose values you want to spread across new columns.
   
6. Great the Rows is now converted to Columns as stated below
   

---

See Also

• Hide Filter Pane In Power BI
• Change Or Remove “Click Here To Follow Link” In Power BI