Can't build a proper graph... :-( can anyone advice, what do I do wrong?

[Katja262373]

Dear all, could you please advice, how can i build a proper graph to represent the migrant flows in EU countries per country as LINES, not colums

(with years 2014,2015, 2016,2017, 2018,2019, 2020 which should be located along the x-axis, not along Y-axis)?

(@ Power Query I have these rows and columns at the moment) - please see the printscreens below...

I manage to create the diagram with the names of the countries below along the X-axis and the sums per year represented as columns, but i don't need that - I need to see the countries names along the Y-axis and the sums per year represented as lines...

data source (power query)my current graph with columns (which I need to change)..

 current (incorrect) graph...

and below is an example of a graph, which I'd like to create...

example of a graph, which I'd like to get

I'd be very grateful, if someone can advice, how to solve this puzzle...

[HotChilli]

In Power Query, Unpivot the year columns.  Then use the line chart visual.

I don't understand this part of the request - "need to see the countries names along the Y-axis". The Y-axis will have a numeric scale.  You will put the 'geo' field in the Legend.

[Katja262373]

Thank you a lot HotChilli for your kind response! I've tried to unpivot the columns, but now i get this error @ Power Query...