Spark line not showing in column of table matrix

[john4614]

Hello everyone, I am experiencing a problem with a sparkline I setup within a column. I do not get any errors in my DAX code and I changed the value for to Image-URL. It seems like a box for the sparkline gets created for the column but there is no image in it. I wonder what could be the issue. Below is my code:

Sparkline = 
// Static line color
VAR LineColor = "#01B8AA"
// "Date" field used in this example along the X axis
VAR XMinDate = MIN(Kalender[MaandNr])
VAR XMaxDate = MAX(Kalender[MaandNr])
// Obtain overall min and overall max measure values when evaluated for each date
VAR YMinValue = MINX(VALUES(Kalender[MaandNr]),CALCULATE([Actuals2]))
VAR YMaxValue = MAXX(VALUES(Kalender[MaandNr]),CALCULATE([Actuals2]))
// Build table of X & Y coordinates and fit to 100 x 100 viewbox
VAR SparklineTable = ADDCOLUMNS(
    SUMMARIZE(Kalender,Kalender[MaandNr]),
        "X",INT(100 * DIVIDE(Kalender[MaandNr] - XMinDate, XMaxDate - XMinDate)),
        "Y",INT(100 * DIVIDE([Actuals2] - YMinValue,YMaxValue - YMinValue)))
// Concatenate X & Y coordinates to build the sparkline
VAR Lines = CONCATENATEX(SparklineTable,[X] & "," & 100-[Y]," ", [MaandNr])
// Add to SVG, and verify Data Category is set to Image URL for this measure
VAR SVGImageURL = IF(HASONEVALUE('KPI Data (2)'[Actual]),
    "data:image/svg+xml;utf8," & 
    "<svg xmlns='http://www.w3.org/2000/svg' x='0px' y='0px' viewBox='0 0 30 120'>" &
     "<polyline fill='none' stroke='" & LineColor & 
     "' stroke-width='5' points='" & Lines & 
     "'/></svg>",
     BLANK())
RETURN SVGImageURL

[v-deddai1-msft]

Hi @john4614 ,

No, you just need to set them in measure. Please refer to https://www.w3schools.com/graphics/svg_polyline.asp

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

Best Regards,

Dedmon Dai

[v-deddai1-msft]

Hi @john4614 ,

Would you please try to change the last part of your code to:

VAR SVGImageURL = IF(HASONEVALUE('KPI Data (2)'[Actual]),
"data : image/svg+xml;utf8," &
"<svg xmlns='http://www.w3.org/2000/svg' x='0px' y='0px' viewBox='0 0 30 120'>" &
"<polyline fill='none' stroke='" & LineColor &
"' stroke-width='5' points='" & Lines &
"'/></svg>",
BLANK())

For more details, please refer to https://gist.github.com/deldersveld/62523ca8350ac97797131560cb317677

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

Best Regards,

Dedmon Dai

[john4614]

Thanks for the reply, however it is still not rendering the image. I think it must be a small issue somewhere but I do not know what it could be.

[v-deddai1-msft]

Hi @john4614 ,

Just based on my test, the code I use can render the image:

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

Best Regards,

Dedmon Dai

[john4614]

Okay, I tried your exact test code on my company laptop and personal PC and both got this broken image. I also used the image url category. Do I need to check my settings?

[john4614]

Hi Dedmon, thanks for the info. It seems like it helps. It looks like the image just doesn't want to render.

[v-deddai1-msft]

Hi @john4614 ,

I have edit my original reply, please pay attention to the bold part.

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

Best Regards,

Dedmon Dai

[lbendlin]

what's the rationale behind:

IF(HASONEVALUE('KPI Data (2)'[Actual])

 ?

[john4614]

Hi, I think that was a little mistake. Now I placed the category there instead.