Create multi-series scatter plot

[Clim054]

Hi,

I have at least 3 different tables where I'm to plot depth against [values] within a single scatter plot graph. I could do it easily in excel with the multi series selection but realised in Power Bi that it might have to come from a single table? I've seen tutorials showing scatter plot pointers differing by shape. Hoping to reduce the amount of pre-processing of data before ploting on Power Bi.

I would also need the option to change the setting of having lines connecting pointers together for some series, not all.

Any suggestions?

Thanks.

[amitchandak]

@Clim054 , you can have legends. and details. These can be text. Details can be like city/line id. The legend can ve something to differentiate between the three tables. But you need to have all of them together when you want to plot. So you can have common dimensions and measures that add up all values

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter

https://radacad.com/storytelling-with-power-bi-scatter-chart