Line chart visual

[uc]

Hello

I created a table in Power BI desktop using Enter data under home tab.

Region	Quater 1	Quater 2	Quater 3	Quarter 4
East Midlands	91.00%	95.67%	88.56%
England	81.00%	84.00%	86.00%
Leicestershire	79.01%	78.02%	75.33%

I wanted to create a line graph showing the comparison between the 3 regions as in the attached snapshot. I know it is possible in excel but not sure how in Power BI.  Any advise is much appreciated. Thanks 

[Anonymous · Accepted solution]

You can unpivot the data in Power Query (Transform) and have the data like this:

Then add a line chart: