Forum Discussion
Multi-variable Scatter Plot
If I am understanding your table correctly, the numbers in each Compound Column represent the concentration that you want to display on the X axis, correct? If so, try the following steps:
1. Load the table into PowerBI and edit the query.
2. Select all of your Compound columns and choose the Unpivot feature within the transform tab.
3. Add an index column
4. Close and Apply
5. Add the scatter chart visualization to your report page
6. Add Index to the Details field
7. Add Attribute to the Legend field
8. Add Value to the X Axis
9. Add Sample Depth to the Y Axis
10. Add slicers for Attribute and Location to filter the chart based on what you want to see.
Does this solve your problem? Final product should look like
If I am understanding your table correctly, the numbers in each Compound Column represent the concentration that you want to display on the X axis, correct? If so, try the following steps:
1. Load the table into PowerBI and edit the query.
2. Select all of your Compound columns and choose the Unpivot feature within the transform tab.
3. Add an index column
4. Close and Apply
5. Add the scatter chart visualization to your report page
6. Add Index to the Details field
7. Add Attribute to the Legend field
8. Add Value to the X Axis
9. Add Sample Depth to the Y Axis
10. Add slicers for Attribute and Location to filter the chart based on what you want to see.
Does this solve your problem? Final product should look like
Thanks the solution really helped me