Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
4 years ago
Solved

Transforming data in Power BI

Hi,

 

I need to transform data.

Now I have this situation:

But I need to transform table in order to get something like this:

 

  • If you go into transform

    data (Power Query).

    Select the objective and name columns (hold shift). Then find the unpivot button, clixl

    down arrow and click unpivot other columns.

     

    You can then rename the columns.