SVG in Power BI – Part 4 – Adding SVG Text

Series

This is part of a series on using SVG in Power BI. The series supports my session at Power BI Days in Mechelen, Belgium in April 2019.

This is the fourth post in my series on using SVG in Power BI introducing adding SVG text and actually solves one of the niggles I had with doing KPI figures in Power BI. I didn’t get to do this part as part of my session which started this series. Here is the list of posts.

KPI Visual

My niggle was the KPI visual. It is a fast way to have a red or green measure displayed. BUT, it requires a trend axis even if you don’t want one and it includes a tiny red exclamation mark or green tick. So I wanted the red / green and the goal shown with no trend or ticks and exclamation marks.

Simple Text Element

SVG Text elements need an x and y attributes to position the text and a style attribute that uses CSS notation to choose font properties. The example below has the word Hello where the bottom lower left corner is at 20,60.

1
2
3
4
5
6
7
8
Text Measure = 
// svg essentials
    var svg_start = "data:image/svg+xml;utf8,"
    var svg_end = ""
// text element including a style tag
    var svg_text ="Hello"
return
    svg_start & svg_text & svg_end

hello

Aligning SVG Text

If I am going to replace the KPI visual I need to place a number centred in the SVG graphic. The default alignment is the x and y are the bottom left. This can be changed using the text-anchor attribute for the text element; it can be set to start, middle or end.

Below is an example of the string ABC being aligned start, middle and end.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
Text Measure = 
// svg essentials
    var svg_start = "data:image/svg+xml;utf8,"
    var svg_end = ""
// text element including a style tag
    var svg_text1 ="ABC"
    var svg_text2 ="ABC"
    var svg_text3 ="ABC"
return
    svg_start & svg_text1 & svg_text2 & svg_text3 & svg_end

aligning text

My KPI Visual

To replace the KPI shown at the start of this post I want a number in the middle of the square showing the measure, bottom left the goal and bottom right how close to the goal we were.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
My KPI = 
// svg essentials
    var svg_start = "data:image/svg+xml;utf8,"
    var svg_end = ""
// 3 text elements, actual, goal and % close
    var svg_Indicator =""
                        & FORMAT([Total Sales],"#,##0") & ""
    var svg_goal =  "Goal"
                    & ""
                        & FORMAT([Target Sales],"#,##0") & ""
    var svg_close =""
                        & FORMAT([KPI Close],"0%") & ""
return
    svg_start & svg_Indicator & svg_goal & svg_close & svg_end

SVG KPI

Format function is used to format the number into comma, #,##0 and percent, 0% formats.

The last part is to colour the number based on the Indicator reaching the target. This was covered in Part 2 of this series so I’ll just give the final code.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
My KPI = 
// svg essentials
    var svg_start = "data:image/svg+xml;utf8,"
    var svg_end = ""
    
// calculate colour for element
    var ind_colour = IF([Total Sales]"
                        & FORMAT([Total Sales],"#,##0") & ""
    var svg_goal =  "Goal"
                    & ""
                        & FORMAT([Target Sales],"#,##0") & ""
    var svg_close =""
                        & FORMAT([KPI Close],"0%") & ""
return
    svg_start & svg_Indicator & svg_goal & svg_close & svg_end

add colour to KPI

My KPI in a Table

One advantage of the SVG text KPI over the KPI visual is it can be embedded within a table. The total line will work as long as the number measures work.

table of svg kpis

Conclusion

Adding SVG text to a visual does make the visual more informative and the above example makes conditional formatting and data layout possible in a table.