Forum Discussion
Using a different variable from the one in the legend to determine shape in a Scatter Plot
I am very new to powerBI, but I can't seem to find information on how I have a scatter plot in which I want my data points to be segmented along two lines: program of study and by type of school. I want the datapoint color to be determined by program of study and the shape to be determined by type of school. Is there an additional step I need to take in order to segment data past a single variable?
2 Replies
Here's a small sample of the data:
Student_Num Inst_id Inst_me Prog_number student_deg school_type Repay_rate adjusted_earn3 cost median_income_earn pgm_rr2 new_med Net_earn pass1 pass2 Eval Prog pgm_rr2_Z_score net_earn_Z_score Repay_rate_outlier Net_earn_outlier 1 1002 Alabama A & M University 1 BA Public 1.046812 21160 -0.04681 21160 Fails Rate of Repayment Fails Rate of Repayment Agriculture, Agriculture Operations, and Related Sciences -1.30885 No 2 1002 Alabama A & M University 1 MA Public 1.125448 21160 -0.12545 21160 Fails Rate of Repayment Fails Rate of Repayment Agriculture, Agriculture Operations, and Related Sciences -1.93801 No 3 1002 Alabama A & M University 1 PhD Public 21160 21160 Agriculture, Agriculture Operations, and Related Sciences 4 1002 Alabama A & M University 3 BA Public 0.940141 21160 0.059859 21160 Passes Rate of Repayment Passes Rate of Repayment tural Resources and Conservation -0.59517 No 5 1002 Alabama A & M University 4 BA Public 21160 21160 Architecture and Related Services 6 1002 Alabama A & M University 4 MA Public 1.070331 21160 -0.07033 21160 Fails Rate of Repayment Fails Rate of Repayment Architecture and Related Services -1.61644 No 7 1002 Alabama A & M University 9 MA Public 1.136546 21160 -0.13655 21160 Fails Rate of Repayment Fails Rate of Repayment Communication, Jourlism, and Related Services -1.83506 No 8 1002 Alabama A & M University 10 BA Public 1.052005 1638.949 21160 -0.05201 21160 Fails Rate of Repayment Fails Rate of Repayment Communications Technologies/Technicians and Support Services -0.98605 No 9 1002 Alabama A & M University 11 BA Public 1.036932 47276.47 1916.513 21160 -0.03693 21160 24199.96 Fails Rate of Repayment Passes Net Earnings Fails Rate of Repayment and Passes Net Earnings Computer and Information Sciences and Support Services -0.91956 -0.14561 No No 10 1002 Alabama A & M University 11 MA Public 1.120608 21160 -0.12061 21160 Fails Rate of Repayment Fails Rate of Repayment Computer and Information Sciences and Support Services -1.45767 No And here's a picture of the visualization that I currently have:
I want to keep dots colored by program of study and shaped by one of 3 school types: public, private, for-profit.
