Scatter Plot with Quartile Curves

Hi PowerBI Experts,

I need to plot a scatter chart using the following columns:

1.Columns (Sum of Drilled interval (m) (x),Sum of Dry hole days (y),well) for plotting X ,Y Axis and the Wells.

2.Columns (Ordered x-values,P25 y-values,P50 y-values) for plotting the curves as shown below.

Please Note:

The first row of the below table shows the respective columns.

And "Ordered x values" are the 10 equally-spaced values.

Sum of Drilled interval (m) (x),Sum of Dry hole days (y),well,_calclogy,Index,RegressionY,Actualy/Regressiony,_index,CalculatedColumn,Ordered x-values,Ordered y,P50 y-values,trial_values,P25 y-values

1936	32.81	well 1	3.49073334697301	0	29.2679038470968	1.12102322637822	0	0	0	9.38434210870477	9.35119327011312	360.25	6.63983135424189
1651	19.81	well 2	2.98618686071046	1	24.7554776254774	0.800226935618171	1	360.25	360.25	11.5964445247101	11.5554817525377	360.25	8.2049902977721
1904	22	well 3	3.09104245335832	2	28.722783994467	0.765942465891816	2	360.25	720.5	14.3299896846194	14.2793710573813	360.25	10.1390927261316
2882	58.48	well 4	4.06868481544152	3	51.0237079323432	1.14613387324856	3	360.25	1080.75	17.7078934774995	17.6453428910136	360.25	12.5291069919982
1195	9.84	well 1	2.28645571106416	4	18.937332930508	0.519608544461285	4	360.25	1441	21.8820458570889	21.8047506777605	360.25	15.4825018625532
1383	10.12	well 2	2.31451366385932	5	21.1489447627398	0.478510871985887	5	360.25	1801.25	27.0401406864237	26.9446252790859	360.25	19.1320789324472
1782	12.23	well 3	2.50389194969908	6	26.7360433343588	0.457434925843462	6	360.25	2161.5	33.414115531829	33.2960849752256	360.25	23.6419441461646
1630	21.71	well 1	3.0777729838902	7	24.451920285627	0.887864828054478	7	360.25	2521.75	41.2905809079236	41.1447278703833	360.25	29.2148869437511
1483	118.92	well 2	4.7784509981299	8	22.4287257739499	5.302129117746	8	360.25	2882	51.0237079323432	50.843474023668	360.25	36.101498838645
1904	33.89	well 3	3.52311998561896	9	28.722783994467	1.17989955313971	9	360.25	3242.25	63.0511538932114	62.8284347617888	360.25	44.6114414512812
1175	18.65	well 4	2.92584614608982	10	18.7161119732933	0.996467643846776
1329	29.69	well 1	3.39081028877567	11	20.4884978220351	1.44910574986463
1844	37.2	well 2	3.6163087612791	12	27.7279009070379	1.34160894922117
1845	18.01	well 3	2.89092715918786	13	27.7441965359936	0.649144767145625
1340	32.96	well 4	3.49529470504127	14	20.6213392335717	1.59834429891638

Need Help

Forum Discussion

Scatter Plot with Quartile Curves

Related content

S - Curve

Create S-curve into my scatter chart in PowerBI

Scatter Chart

quartile ranking

Scatter chart.