How can I pivote my data in Power BI Desktop?

[Christann]

Hi all,

My data looks like this:

I am hoping to pivote the type column so as to create one sales amount column and one Tax Rate column. I tried selecting the Type column and hit Pivote on the Transform Tab, but got all rows for both columns as the value 1. Do you have any ideas why this is happening, or what I should do differently?

[ImkeF · Accepted solution]

You get the count returned.

Instead you have to go to the advanced options and choose "don't aggregate".

[Christann]

Thanks for the reply! I tried selecting don't aggregate but am still getting the value 1 for both columns. You can see from my previous screenshot that the data is different for the different locations.

[ImkeF]

Please paste screenshot of the result after the pivot.

[Christann]

Here is what it looks like after I pivot the data.

[Christann]

I just tried selecting both the Type column and the Values column then Pivoting the data with Don't Aggregate which gave me the correct values. Thank you so much for your help!