Forum Discussion
Scatter Chart: Comparing values in same column
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
So, what would be an example of what you would like to see as output?
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 |
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