Power BI Custom Visual Part 5 – Formatting

Setting up the formatting options turns out to be the most fiddly bit of developing a custom visual. There are a few “special” property names that are required to trigger some behaviours, undocumented features and at least one bug that I’ve come across. In this section I’ll explain how the options are set up for the Tree Funnel visual and in an extra post I’ll talk about some of the other issues and features. Continue reading “Power BI Custom Visual Part 5 – Formatting”

Power BI Custom Visual Part 4 – Accessing the DataView

In understanding how to access the data in a custom visual I found AB Kimmel’s tutorial incredibly helpful. Here I’m just going to go through the options I need, for a broader explanation I’d recommend reading his sections on data views. There are four steps to go through. First specify what data can be added to the visual via the Fields pane – this data will then be accessible via the dataview. Then create a data model to hold this data and a function to populate it from the dataview. And finally use the data model data to draw the visual. Continue reading “Power BI Custom Visual Part 4 – Accessing the DataView”

Power BI Custom Visual Part 2A – SVG blend lines between elements

When drawing the paths for the Tree Funnel visual I noticed an unsightly line between each horizontal. Initially I thought this would be due to a small error in the stroke width introducing a gap but actually the calculation is perfect and each path is exactly adjacent. The lines are actually due to the anti-aliasing of each path. Continue reading “Power BI Custom Visual Part 2A – SVG blend lines between elements”

Power BI Custom Visual Part 2 – Creating a Tree Funnel Chart

Power BI Visuals basically render a bunch of HTML to display a chart. Typically these will be SVG elements and most likely use the D3 library to help draw them. So when I started on developing a Power BI Custom Visual it made sense to develop the chart rendering separately and worry about how to hook it into the Power BI Visual after I was happy with the basic chart logic. This section then is purely D3. Continue reading “Power BI Custom Visual Part 2 – Creating a Tree Funnel Chart”

Power BI Custom Visuals Part 1 – Introduction

I’d been interested in developing a Power BI custom visual for a while before actually getting round to producing something. The usual constraints on time were one reason but also the rather limited documentation and the number of components required which I have at best a surface knowledge of: Typescript and D3 in particular. Having finally found the time I found that the process was not too painful even starting from a pretty low base. The documentation however was sparse and so before detailing how I got on I thought I’d outline the resources I found useful. Continue reading “Power BI Custom Visuals Part 1 – Introduction”

Charticulator for Dummies

A graphical tool for developing complex chart designs in minutes that can be exported as custom visuals directly to Power BI. Too good to be true? Maybe, but Charticulator is still an amazing bit of kit and to be fair it’s primarily intended to produce charts for the Web not for Power BI.

Charticulator is developed by Microsoft Research which means some very smart people worked on it and though there are plenty of tutorial examples as a lesser mortal I struggled a bit to understand how everything worked. So I’m sharing a very basic example here which explains the issues that confused me. In a separate post I’ll talk about how the export to Power BI and whether it really works. Continue reading “Charticulator for Dummies”