Forum Discussion
Charting an Electrocardiogram from a single value
- 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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
- Edisonsepulveda3 years agoNew Member
Thank you