Basic Sparkline/Small Multiple Measures in Power BI
Sparklines and small multiples are incredibly powerful. They allow you to add a tiny simple graph to a table or a matric that conveys the basic idea or shape of the data in a way that is compact enough to allow for a chart per row of a table, or per intersection of a matrix.
In Power BI however, these solutions don't come as a simple one-click option. In fact, up until now they have been essentially impossible to add to a table or matrix.
With the August release of Power BI however we now have the ability to code measures as returning image urls, further we can trick this feature into return SVG images that aren't stored somewhere on the web, but are instead generated in real time for your tables and matrices. That means these charts are 100% dynamic and respond to any slicing, dicing, or cross filtering a user can throw at them. This is an awesome technique, but it's hard to understand and implement. In this video we will walk you through a simple but powerful implementation that you can recreate for your own solutions.
Just noticed David's GIT for his version of this. I came up with mine independently (mainly to see if I could) but since he posted his first I wanted to reference it here. Also excellent tip. In the code I should have replaced the hashtag with a %23 so it will work in Firefox. Take a look to see how his differs (good stuff):
https://gist.github.com/deldersveld/6...