Scatter Chart: Comparing values in same column

[vincentakatoh]

Hi, 

Below is my sample data, can I create a scatter chart "length vs width"? 

Objective: For the same serial number, is there a trendline between length vs width, length vs height, width vs height

Actul data has more >50 parameters and millions of rows. 

serial number	Parameter	Value
1111	Length	10.1
2222	Length	10.2
3333	Length	10.1
1111	width	5.2
2222	width	5.3
3333	width	5.1
1111	height	2.1
2222	height	2.2
3333	height	2.4

[Greg_Deckler]

So, what would be an example of what you would like to see as output?

[vincentakatoh]

@Greg_Deckler,

Updated table values and below is a sample chart (length vs width). 

At some point, I will also need a slicer to select "length" and "width".

serial number	Parameter	Value
1111	Length	14
2222	Length	15
3333	Length	14
4444	Length	9
5555	Length	3
1111	width	19
2222	width	20
3333	width	19
4444	width	14
5555	width	8
1111	height	22
2222	height	23
3333	height	22
4444	height	17
5555	height	11

  

[v-yuezhe-msft · Accepted solution]

@vincentakatoh,

Create the following measures in your table.

LengthMeasure = CALCULATE(SUM('Length table'[Value]),FILTER('Length table','Length table'[Parameter]="Length"))
widthmeasure = CALCULATE(SUM('Length table'[Value]),FILTER('Length table','Length table'[Parameter]="width"))
heightmeasure = CALCULATE(SUM('Length table'[Value]),FILTER('Length table','Length table'[Parameter]="height"))

Then create scatter chart as shown in the following screenshot. Please note that in this case, it is not possible to parameter slicer to filter the charts.

Regards,
Lydia