scatter plot multiple series

[goalie_]

Hi all, I want to plot multiple series on the scatter plot visualization. Using data below as an example. Relating the temperature to % of transportation modes. I have data structured as below:

Table 1

country ID	replicate	region	temp
1	1	north	25
1	1	south	13
1	1	east	5
2	1	north	30
2	1	south	8
2	1	east	12
3	1	north	67
3	1	south	3
3	1	east	17

 and another table. Both are connected via the ID column

Table 2

country ID	transportation mode	%
1	car	25
1	bus	68
1	train	7
2	car	13
2	bus	40
2	train	47
3	car	35
3	bus	54
3	train	11

T

I have tried to make a scatter plot as Legend = Table1[ID], X-axis = Table2[%], Y-axis = Table1[temp]. I have a slicer for the region and transportation mode I have to select. and Each dot is individually colored by the ID.

I'd like to have a scatter plot such as. Please excuse the rudimentary drawing

edit:

For table 1, I forgot to mention there are multiple replicates of the temp taken for each country, region. I can do Legend = Table1[region], X-axis = Table2[%], Y-axis = Table1[temp] and that works for above. However it only works if I have a slicer with one replicate chosen. For each country, region pair, I want the average of all the replicates. Maybe a measure somehow?

[Icey · Accepted solution]

Hi @goalie_ ,

How about put "%" or "temp" column into "Details" field?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.