Power pivot or dax calculated table to combine columns data and create new rows line chart viz

[PatrickNahayo]

I need to have the data transformed in the following way, the first table shows how I'm receiving the information and the second show how the output table should be with the year and amounts for each product. 

I should be able to do it for multiple product lines so that i can visualize the evolution of one or more products.
if there is a measure to visualize the information as below or any power pivot trick, i'm open to ideas to have the following outcome so that we see variations over years (AND THIS I DO NOT KNOW HOW TO DO WHEN DATA IS IN MULTIPLE COLUMNS)

[MFelix · Accepted solution]

Hi @PatrickNahayo ,

For this you need to unpivot the information based on the colunmns of the year.

Then you can remove the total sales column and use this new table on your chart directly.

[MFelix · Accepted solution]

Hi @PatrickNahayo ,

For this you need to unpivot the information based on the colunmns of the year.

Then you can remove the total sales column and use this new table on your chart directly.

[PatrickNahayo · Accepted solution]

Thanks very much. I'll appreciate if you can share indepths articles about Pivots anad Unpivots stuff.