Forum Discussion

Edisonsepulveda's avatar
Edisonsepulveda
New Member
3 years ago
Solved

Charting an Electrocardiogram from a single value

Hi All,   I'm trying to chart an Electrocardiogram from a  value that contains 2500 values separated by a space. My dataset looks like this: I'm trying to create a chart with the numbers in ...
  • v-yanjiang-msft's avatar
    3 years ago

    Hi Edisonsepulveda ,

    According to your description, here's my solution.

    Sample:

    1. Replace value in Power Query. For the Value column, replace space to "|".

    2.Create a calculated column.

    PathNo =
    PATHLENGTH ( [Value] )
    

    3.Create a new table.

    Table 2 =
    GENERATESERIES ( 1, MAX ( 'Table'[PathNo] ), 1 )
    

    4.Create a measure.

    Measure =
    CONVERT (
        PATHITEM ( SELECTEDVALUE ( 'Table'[Value] ), MAX ( 'Table 2'[Row] ) ),
        INTEGER
    )
    

    Put Row column in X-axis and measure in Y-axis, get the correct result.

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

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