frequency table creation and Scatter plot

Question

Hi,&nbsp;I am fairly new to Power&nbsp; BI, I want to recreate the scenaro below on power bi. the below is an excel sample table chosen from Sample sites.&nbsp;VolumeNew Frequency&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 106,910.001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 173,218,900.1814&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 346,330,890.376&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 519,442,880.551&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 692,554,870.741&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 865,666,860.920&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,038,778,851.100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,211,890,841.290&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,385,002,831.470&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,558,114,821.651&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,731,226,811.840&nbsp;&nbsp;VolumeNew Frequency0=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)&nbsp;&nbsp;Thank you&nbsp;

v-yuta-msft · Answer

Hi&nbsp;Fuel&nbsp;,
&nbsp;
Could you explain more details about your requirement?
&nbsp;
Regards,
Jimmy Tao

Forum Discussion

frequency table creation and Scatter plot

1 Reply

Related content

Report creation

Scatter Chart

New connection Creation

Scatter chart.

Creation of fabric account

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)