Pivot Data

[Anonymous]

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

[Seward12533 · Accepted solution]

@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.