As a column, it works in unique cases where user selections and filtering won’t affect the result. When the day comes where Power BI renders image URLs on measures and not simply columns though, the technique outlined here will become even more powerful and useful. The radius and opacity of the circle indicators/KPIs are adjusted based on data. You can even add data from other columns, or in this case, DAX’s TODAY() function directly into the SVG.įinally, here’s a more complex example inspired by some research I did recently for my BlueGranite colleague Meagan Longoria. This leads to the ability to quickly and easily create and update images for indicators or other uses without having to edit image files in an outside program. In addition to advantages such as scaling without losing image quality, having SVG as plain text allows you to dynamically change the image using text replacement and/or concatenation. When you change the Uncategorized text to an Image URL, the image appears. I’m illustrating this using a calculated column in DAX for convenience sake, but you could add this prefix in the data source or in Power Query as well. It’s possible to add SVG as plain text by adding a short prefix to the beginning of your column: data:image/svg+xml utf8,įor SVG encoded as Base64, simply swap out utf8 for base64: data:image/svg+xml base64, For SVG, Base64 is an option, but it is not required. If you are familiar with embedding Image URLs using Base64 as outlined by Jason Thomas and Gerhard Brueckl, it’s a similiar process. Instead, the SVG needs to be added as a data URI. Notice how the SVG alone cannot be categorized as an Image URL. Having the text of the SVG is not good enough though. To illustrate this, I’ve added the column and dropped it into a Table visual.

You’ll need to add everything between the and tags to a column.

To work with SVG in this manner, extract the text of an SVG image as outlined in Part 1. This puts SVG on par with how we currently use non-vector image types such as PNG, employing them as indicator columns in the Table visual or in other creative ways. The following technique is available for use with any visual that renders Image URLs as an image. In addition to using SVG in the HTML Viewer custom visual as outlined in previous posts ( Part 1, Part 2), Power BI allows you to work with SVG images as Image URLs.

Thank you svg image