Forum Discussion

uc's avatar
uc
Helper II
2 years ago
Solved

Line chart visual

Hello

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

RegionQuater 1Quater 2Quater 3Quarter 4
East Midlands91.00%95.67%88.56% 
England81.00%84.00%86.00% 
Leicestershire79.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 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

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

    Then add a line chart: 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

    Then add a line chart: