Line Graph Visual

[Unicorn_Tech]

I have a table visual in Power BI that shows

'new_country'[Country Name]
'archive'[2022]

'archive'[2023]

'current'[area]

archive and current tables are related to new_country by country_value.

The table looks fine, but I want to turn this into a linegraph, measuring growth from 2022 to current.  Simply chosing the line graph visual doesn't work - can I get some advice on how I can transform my data so that I can have this line graph visual?

Original table below

Attempt at line graph - the issue is that i don't have a single column called "Values", of different types of 2022, 2023 and current.

[HotChilli]

That's a bit more helpful but I need to see a data sample of the original tables (Archive and current)

[HotChilli]

There's not enough info to help you.

Have a read of this and repost please.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/3095... 

[Unicorn_Tech]

Hi.  I added screenshots.  I'm not sure what else to do here.

[Anonymous]

Hi @Unicorn_Tech 

Perhaps you can describe the desired outcome of the line chart. Based on my understanding, there are three relevant fields needed: Year, Country and Values. If you hope to have Year on X-axis and Values on Y-axis, you have to transform data into a table which has all years in 'Year' column and all values in 'Values' column. Then you can probably use a slicer to hold the Country column, and use it to filter countries. You can also add Country to Legend of the line chart, thus every country will have a line on the chart. You can also try adding Country to Small multiples, thus every country will have a line chart visual. 

Best Regards,
Jing