Forum Discussion
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:
- Go to the Power Query and click like this:
Then you can get the correct data model like this:
- 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.
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:
- Go to the Power Query and click like this:
Then you can get the correct data model like this:
- 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.