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.
