Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Pivot Data

Hi,

 

I am relevatively new to Power BI and have looked through a few of the previous posts regarding pivtoing data but I dont seem to find what I need. Below is an example data set, where the numer of sales of each car in each month is represented in the Mar-18/Apr-18 columns.

 

CarPriceMar-18Apr-18
Nissan$50012
Toyota$70034

 

What I need to do is pivot the data from the Mar-18 column, creating two new columns, Month and Sales and adding extra rows.

 

CarPriceMonthSales
Nissan$500Mar-181
Nissan$500Apr-182
Toyota$700Mar-183
Toyota$700Apr-184

 

This can be done in tableau, but I am having trouble with Power BI. Maybe I am missing something, any ideas?

 

Many Thanks,

 

JBPowerBI

1 ACCEPTED SOLUTION
Seward12533
Solution Sage
Solution Sage

@Anonymous  The best place to do this in PowerBI is in the Query Editor. Highliht the columns you want to unpivot and then chose unpivot from the Transorm menu. capture20180724004154474.png

 

capture20180724004202185.png

 

 

View solution in original post

1 REPLY 1
Seward12533
Solution Sage
Solution Sage

@Anonymous  The best place to do this in PowerBI is in the Query Editor. Highliht the columns you want to unpivot and then chose unpivot from the Transorm menu. capture20180724004154474.png

 

capture20180724004202185.png

 

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.