Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
john4614
Frequent Visitor

Spark line not showing in column of table matrix

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

 

 

 

9 REPLIES 9
v-deddai1-msft
Community Support
Community Support

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
Community Support
Community Support

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

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.

Hi @john4614 ,

 

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

Capture.PNG

 

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

 

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?

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

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
Super User
Super User

what's the rationale behind:

 

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

 ?

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.