frequency table creation and Scatter plot

[SamOla]

Hi, 

I am fairly new to Power  BI, I want to recreate the scenaro below on power bi. the below is an excel sample table chosen from Sample sites.

Volume	New Frequency
-	0
106,910.00	1
173,218,900.18	14
346,330,890.37	6
519,442,880.55	1
692,554,870.74	1
865,666,860.92	0
1,038,778,851.10	0
1,211,890,841.29	0
1,385,002,831.47	0
1,558,114,821.65	1
1,731,226,811.84	0

Volume	New Frequency
0	=FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15)
=E20	=FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15)
=$D$5+E17	=FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15)
=D6+$E$17	=FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15)
=D7+$E$17	=FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15)
=D8+$E$17	=FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15)
=D9+$E$17	=FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15)
=D10+$E$17	=FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15)
=D11+$E$17	=FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15)
=D12+$E$17	=FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15)
=D13+$E$17	=FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15)
=D14+$E$17	=FREQUENCY('Fuel Data by Operation type'!G4:G27,'Sampling '!D4:D15)

Thank you 

[v-yuta-msft]

Hi Fuel ,

Could you explain more details about your requirement?

Regards,

Jimmy Tao