Pivot values to columns

[Anonymous]

Hi,

I have an ID with 3 corresponding questions and a rate :

 ID   QUESTION   RATE

A1      Q1                 2

A1      Q2                 3

A1      Q3                 1

I would like to have this result :

ID   Q1   Q2    Q3  

A1   2      3       1

But I am not able to do it because I can't use RATE in "Values Column", why ? How can i do it, please ?

Thank you !

[themistoklis]

@Anonymous

Are you using a matrix object in PowerBI?

[Anonymous]

Hi themistoklis,

Now for the moment I am building my model in Power Query

[themistoklis · Accepted solution]

@Anonymous

Using PowerQuery simply add the raw data.

Then on visualisations area use a matrix object and add ID as rows, Questions as columns and Rate as Values. Image below