Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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)
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |