Forum Discussion
Line Graph Visual
I have a table visual in Power BI that shows
'archive'[2022]
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
4 Replies
There's not enough info to help you.
Have a read of this and repost please.
Hi. I added screenshots. I'm not sure what else to do here.
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
That's a bit more helpful but I need to see a data sample of the original tables (Archive and current)
