line chart help

[jblackburnHWGA]

I need a bit of help plotting a line graph. Not sure its how i have my data or how i'm using the graph settings

I have 10 sites with finance data over 5 years for each site.

I want to plot the year over the x axis. Each site is a line on the graph. Y is the value. We can then see growth over time or not growth over time.

Excel looks like

site	18/19	19/20	20/21
1	456465	56776	88990
2	435345	67567	80978
3	656345	67674	70077

[v-robertq-msft · Accepted solution]

Hi, @jblackburnHWGA 

According to your description and sample data, I think you can use the “Unpiovit columns” operation in the Power Query to get the correct data model to achieve your requirement, you can try my steps:

1. Go to the Power Query and click like this:

Then you can get the correct data model like this:

2. Click on “Close and apply” and create a line chart and place it like this:

You can also create a slicer for the [Site] to slice the chart by site id, like this:

And you can get what you want.

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jblackburnHWGA]

Yes all working. Many thanks

[lance_6]

You need to structure your data differently to work with that scenario. 
Here is the best way for that: 

 Then put the data in your line chart feilds as follows: 

Axis : `Date`

Legend : `Site`

Values : `Value`

[lance_6]

Did this work for you?

[jblackburnHWGA]

my table didn't come out well lol hope you get the idea