deldersveld's avatar
deldersveld
Resident Rockstar
8 years ago

SVG Sparklines - Line

Power BI now allows the dynamic creation of Scalable Vector Graphics (SVG) images. Prior to the August 2018 version, it was possible to build SVG content into custom columns, but now it is possible t...
Other
KrishnaPaudel's avatar
KrishnaPaudel
Microsoft Employee
7 years ago

Hi,

 

Is it possible to use this when the report is connected to live connection.

 

I was able to get the Image URL but I am unable to change the data category for the calculated measure to ImageURL. Only Uncategorized, Longitude and Latitude options are available, rest are greyed out.

 

Thanks,

Krishna

cmajs's avatar
cmajs
Frequent Visitor
7 years ago

David great post!

Thanks for sharing it. Trying to emulate your model I only get the values string and not the charts. Do am I missing something?

  • deldersveld's avatar
    deldersveld
    Resident Rockstar
    7 years ago

    Did you include the "data:image/svg+xml;utf8," prefix before the SVG text and then set the measure's data category to ImageURL?

    • cmajs's avatar
      cmajs
      Frequent Visitor
      7 years ago

      I think so. This is what I have:

       

      VAR SVGImageURL = IF(HASONEVALUE('Diario'[Cadena]),
      "data:image/svg+xml;utf8," &
      "<svg xmlns='http://www.w3.org/2000/svg' x='0px' y='0px' viewBox='0 0 100 100'>" &
      "<polyline fill='none' stroke='" & LineColor &
      "' stroke-width='3' points='" & Lines &
      "'/></svg>",
      BLANK())
       
       
      • deldersveld's avatar
        deldersveld
        Resident Rockstar
        7 years ago

        Apart from where this forum transformed my reply from an actual colon symbol to &colun, the variable looks good. Is 'Diario'[Cadena] in your table then as well?