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 w...
FrankAT
Community Champion
Community ChampionHi lr2956
please, can you share same sample data?
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
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.