I recently discovered a new feature in PowerPoint – “Cartoon People”. It offers the ability to mix and match bodies, faces and expressions and looked quite a bit of fun. I thought to myself – “Wouldn’t this be interesting if I could make these data-driven?”
So, I thought I’d give it a go 🙂
I first created the bodies, heads and template KPI Card on the PowerPoint Canvas
Then selected two facial expressions and laid them on top of each other
I selected all icons and saved as SVG
In Power BI, I imported the PureViz custom visual, dragged the appropriate fields into the fields well, then imported the SVG.
With PureViz, each individual PowerPoint icon is represented as a group of shapes.
I could select an individual shape within a group, and pick “Custom color …” option
To then apply a Dynamic Formula to make the colour of the shape data-driven
Similarly, I could select a group of shapes, in this case, one of the faces, and create a formula to show or hide the face
The formula I applied was If [Profit::sum] is less than 0.3 then 1 (show) else 0 (hide). I applied a similar formula to the other face – If [Profit::sum] is greater than or equal to 0.3 then 1 (show) else 0 (hide).
I then updated the text value to be data-driven using the Advanced Dynamic Formula.
And voila!! half an hour for a cheeky quick viz!