line chart help

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.