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
Perfect, thank you!
Now that we've come this far, I'm wondering if we can do it 1 more...
If we filter on say compound 1 & 2 they will show up as 2 distinct colors. However, there's no easy way to discern which location we are viewing (by way of symbol or size or something like that). I tried putting the location in for color saturation but it wouldn't take.
Any idea on how to visualize/filter this way?The enhanced scatter has a shape field. If you create a numerical version of the locations you can give them one of these shapes.
circle - 0
cross - 1
diamond - 2
square - 3
triangle-up - 4
triangle-down - 5
star - 6
hexagon - 7
x - 8
up arrow - 9
down arrow - 10Excellent I will try this. The enhanced scatter seems useful but at first I was getting an error about string and aggregate data when trying to use the shape option. This was before seeing your response however so I will reformat my data and see if this works.
Hi Experts,
I am trying to build an scatter chart of X (from K-S columns in the excel sheet image) and Y points (from T to AB columns) arranged in rows within the data file, each row corresponds to a particular object (@name()) and it varies with time (each row represents the object and the date were the X-Y points were recorded), the goal is to build a similar plot to the one shown (i.e. PCCA-001A with coordinates Xn,Yn as: Q_PR, PR/ Q_0.75, PR_0.75…Q_0, PR_0). I tried first to unpivot those X,Y points, then to use an index (1 instead of PR, 0.75, 0.5, 0.4, 0.3, 0.2, 0.1, 0) as suggested here but it did not work out. Any possible solution it would be great. Or if it is possible to plot the scatter without unpivoting let me know.
Best regards,
LG
Thanks the solution really helped me
