Using a different variable from the one in the legend to determine shape in a Scatter Plot

[lr2956]

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?

[FrankAT]

Hi @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)

[lr2956]

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.