Turn 1 record into multiple rows?

[joseph_Dev]

Hello, 

I have a table from Dataverse called new_backlog where each row represents the project information of 1 project.

This is an example of my table:

Columns Cashflow N, Cashflow N+1, Cashflow N+2, Cashflow N+3, Cashflow N+4, Cashflow N+5  represent the Cashflow of the project in year N (current year), year N+1, year N+2, year N+3, year N+4, and year N+5 respectively.

How can I create a graph that plots the cashflow (Y-axis) per its related year (x-axis)?

It should look something like this:

Should I create a row for each project's Cashflow N, Cashflow N+1, Cashflow N+2, Cashflow N+3, Cashflow N+4, Cashflow N+5 under 1 column instead of having them as 6 columns? Example:

If so is there a way to transpose a table into a table (like above) in Power BI?

Thank you in advance for any help, and I am sorry if it is trivial as I am still relatively new to Power BI.

[amitchandak · Accepted solution]

@joseph_Dev , Unpivot the table table

https://radacad.com/pivot-and-unpivot-with-power-bi
Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g