Charting an Electrocardiogram from a single value

Question

Hi All,&nbsp;I'm trying to chart an Electrocardiogram from a&nbsp; 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 the cell and a fixed X-axis value (let's say 2,000). My chart should look like this:I have tried using split.text and Generate series in DAX, but since this is medical data, I want to make sure that if for some reason one data point doesn't have 2,500 points, that I don't mess up the whole thing. What could be the best way to create this graph?&nbsp;Thanks!

v-yanjiang-msft · Accepted Answer

Hi&nbsp;Edisonsepulveda&nbsp;,
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.
&nbsp;
Best Regards,Community Support Team _ kalyj
If this post&nbsp;helps,&nbsp;then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Charting an Electrocardiogram from a single value

2 Replies

Related content

Single Date for line chart in Power BI

Single line Chart with Actual vs Forecast

Gantt Chart - multiple tasks on a single row

Single select slicer

how to create single totals