Forum Discussion

Unicorn_Tech's avatar
Unicorn_Tech
Icon for Resolver I rankResolver I
2 years ago

Line Graph Visual

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_val...
Need Help
Tips and Tricks
Unicorn_Tech's avatar
Unicorn_Tech
Icon for Resolver I rankResolver I
2 years ago

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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