Scatter Chart - For multiple data's (X1,Y1)

[Velmurugan]

Greetings

I would like to Create a mulitiple circles using datas (X1,X2,X3 etc Y1,Y2,Y3 etx) in Power BI. I was able to create a one circle using data through Scatter chart but not multiple circle.

The Same can be done through excel, I would like to do the same in Power BI, Could any one help me to do this?

Attahced image which done through excel for reference. 

Thanks

Vel

[Velmurugan]

@negi007 

Thanks a lot. It works. Appreciate your support and time.

Thanks

Vel.

[negi007 · Accepted solution]

@Velmurugan I could do it using below steps

1. Created one table for all data points 

2. then plotted the data like below

I have attached the powerbi file as well for your reference. 

[Velmurugan]

@negi007 

Thanks for your promt response. I am sharing excel through Google drive link.

https://drive.google.com/drive/folders/1wYYe5mBRqYoLbvvXoQuTMyvLteJpprek?usp=sharing

I would like to replicate same in Power BI.

Thanks

Vel

[negi007]

@Velmurugan In scatter plot, please ensure that you have below fields

Details

X-axis value

y-axis value

Size - size of the bubble

Legend - color of the bubble

first three are mandatory and last two are optional

Below is an example of the scatter plot

if the above does not help you, please let me know and share your data in text format so that i can do simulation on the same.