SVG Sparkline for rolling 12 months in a table matrix

[katyfailoo]

Hi All,

The goal is to have a trailing 12 month sparkline on a matrix table. To achieve this, I used a SVG code . However, I am having issues with my SVG code (see below).

1 Sparkline Matrix_Test =

// Static line color - use %23 instead of # for Firefox compatibility

VAR LineColor = "%2301B8AA"

// X Axis

VAR XMinDate = MIN(DATE(YEAR(TODAY())-1,MONTH(TODAY()),1))

VAR XMaxDate = max(DATE(YEAR(TODAY()),MONTH(TODAY()),1)-1)

// Obtain overall min and overall max measure values when evaluated for each date

VAR YMinValue = MINX(FILTER(GLDate, XMinDate <= GLDate[DATE] && XMaxDate >= GLDate[DATE]),CALCULATE([Sales Amount],'Time Intelligence'[Name] = "MTD"))

VAR YMaxValue = MAXX(FILTER(GLDate, XMinDate <= GLDate[DATE] && XMaxDate >= GLDate[DATE]),CALCULATE([Sales Amount],'Time Intelligence'[Name] = "MTD"))

// Build table of X & Y coordinates and fit to 100 x 100 viewbox [This is where I get stuck]

VAR SparklineTable = ADDCOLUMNS(

SUMMARIZE(GLDate,GLDate[DATE]),

"X",INT(100 * DIVIDE(GLDate[DATE] - XMinDate, XMaxDate - XMinDate)),

"Y",INT(100 * DIVIDE(CALCULATE([Sales Amount],'Time Intelligence'[Name] = "MTD") - YMinValue,YMaxValue - YMinValue)))

// Concatenate X & Y coordinates to build the sparkline

VAR Lines = CONCATENATEX(SparklineTable,[X] & "," & 100-[Y]," ", [DATE])

// Add to SVG, and verify Data Category is set to Image URL for this measure

VAR SVGImageURL = IF(HASONEVALUE(HomeRegion[DIVISION]),

"data&colon;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())

RETURN SVGImageURL

I need some guidance on what am I need to do for the next block of code where I need to build table of X & Y coordinates and fit to 100 x 100 viewbox. Cann anyone help me? Or does anybody have another solution. I am pretty new to adding a sparkline to the matrix. 

[rufmau68]

Im new in pbi but

if I wish to build a cumulative sum sparkline ?

how have to change SparklineTable

[v-lionel-msft · Accepted solution]

Hi @katyfailoo ,

Step1, Check whether the “LineColor” and the “Lines” parameters return the correct value.

Step2, modify the SVG code.

Measure = 
// My test
//Do not copy the following code directly, “data:image/svg+xml;utf8” has changed.
"data:image/svg+xml;utf8," &
"
<svg xmlns='http://www.w3.org/2000/svg' version='1.1' x='0px' y='0px' viewBox='0 0 100 100'>
  <polyline points='20,20 40,25 60,40 80,120 120,140 200,180' style='fill:none; stroke:#2301B8AA; stroke-width:3' />
</svg>
"

The most important thing is not to forget to set the measure to "Image URL".

Or please provide your sample .pbix file if your problem is still not resolved

Best regards,
Lionel Chen

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

[Greg_Deckler]

@katyfailoo - SVG Sparklines - Line (powerbi.com) Try this Quick Measure gallery entry.

[amitchandak]

@katyfailoo , you have already checked these links ?

https://www.youtube.com/watch?v=xLD8HKwPWHE

https://community.powerbi.com/t5/Desktop/SVG-Image-Sparklines-on-rows-in-Power-BI-table/m-p/1169515#...