Best way to split a single table into 2 views

Hi, lutho 

According to your description, I guess that you want to split your single table into the 2 dimensions and show the data in the scatter chart, you can follow my steps:

This is the test data I created based on your picture:

1. I click “Transform data” to go to the Power query editor, select the table, and click “Piovit column” then set like this:

2. And I get the data you want to get, like this:

3. Then I click “Apply and close” and go to the report view to create a scatter chart then place columns like this:

And you can get what you want.

You can download my test pbix file here

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.