Forum Discussion
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.
| Car | Price | Mar-18 | Apr-18 |
| Nissan | $500 | 1 | 2 |
| Toyota | $700 | 3 | 4 |
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.
| Car | Price | Month | Sales |
| Nissan | $500 | Mar-18 | 1 |
| Nissan | $500 | Apr-18 | 2 |
| Toyota | $700 | Mar-18 | 3 |
| Toyota | $700 | Apr-18 | 4 |
This can be done in tableau, but I am having trouble with Power BI. Maybe I am missing something, any ideas?
Many Thanks,
JBPowerBI
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.
1 Reply
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.