Forum Discussion

vincentakatoh's avatar
vincentakatoh
Helper IV
8 years ago
Solved

Scatter Chart: Comparing values in same column

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 hei...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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

  • vincentakatoh's avatar
    vincentakatoh
    Helper IV
    8 years ago

    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 numberParameterValue
    1111Length14
    2222Length15
    3333Length14
    4444Length9
    5555Length3
    1111width19
    2222width20
    3333width19
    4444width14
    5555width8
    1111height22
    2222height23
    3333height22
    4444height17
    5555height11

     

      

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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