Skip to content

dm-p/powerbi-visuals-chartxkcd

Repository files navigation

chart.xkcd for Power BI

Overview

In August 2019, chart.xkcd was made available, which is a JavaScript library that provides a means to plot “sketchy”, “cartoony” or “hand-drawn” styled charts.

This allows developers to use JSON as a type of "visualisation grammar" to configure charts and then chart.xkcd will use this to generate charts.

Being the enquiring sort that I am, I wondered, "can we put this in a custom visual..?"

Turns out we can. Should we? That's up to you!

What the Custom Visual Does

  • Provides feature parity with chart.xkcd version 1.0.10. Including all bugs. chart.xkcd is in its early stages and a lot of things are still being worked out. Don't let that discourage you. It's great, and data can be fun as well as educational :)
  • Provides the Power BI user with access to all functionality via the Properties pane and the right combination of fields.
  • Probably has lots of bugs. Refer to Support below for further details.

Installing the Visual

Due to the high-cadence of chart.xkcd's development and the somewhat experimental nature of the custom visual, the release and testing process employed by the AppSource Marketplace and the Power BI Custom Visuals team means that several updates may be made to either the visual or chart.xkcd before an update eventually gets published. If things stabilise in the future then this stance may change.

For now, you can download and install releases from this repository. You need to either install the .pbiviz file manually into your reports, or you can use the organizational custom visuals capabilities of your tenant if you wish to inflict this on everyone. You might really want to rethink this option if it seems like a good idea.

Please be careful when installing custom visuals from unknown or unsolicited sources. I can assure you that my intentions are honourable but you should exercise caution around your data. If you have any doubts, then work with your admins to ensure that all the necessary checks and balances are carried out.

Version Direct Download Release Notes Sample Workbook
1.0.1.1 1.0.1.1.pbiviz Read more Link
1.0.0.0 1.0.0.0.pbiviz Read more N/A

Using the Visual

As at this time the visual supports all types available in version 1.0.10 of chart.xkcd and their available configuration. The visual exposes 3 property menus for the creator:

  • Core Parameters - allows selection of chart type and setting of parameters in the chart.xkcd spec that sit outside the chart-specific options.
  • Chart Options - provides properties that drive the chart-specific options.
  • About - provides version info (+ version of chart.xkcd packaged with the visual)

Supported Chart Types

Select the Chart Type from the Core Parameters property menu. Supported charts are:

(links go to the chart.xkcd documentation)

Data Roles (Fields)

The visual has 3 data roles (or "field buckets"). Because each chart type has specific behaviour, the visual provides a "best-fit" for each configuration and each chart type will document the "correct" usage of these to produce desired results. A rule-of-thumb is as follows:

  • Category (or X) - represents the x-axis for cartesian charts, or the category for the Pie/Donut chart.
  • Measures (or Y) - represents the y-axis for cartesian charts or the share of the Pie/Donut chart.
  • Legend (Series) - provides an opportunity to further categorise line and XY charts with a different field.

If the selected Chart Type doesn't support the combination of fields, you should get a message confirming this. If you don't get a chart or a message then you've found a bug!

Here are the valid combinations of data roles for each chart type:

Category Measures Series Bar Pie Line XY
1 1 0 ✔️ ✔️ ✔️ ✔️*
1 1 1 ✔️ ✔️*
1 1 or more 0 ✔️

* For the XY chart, the Category must be defined in the Power BI data model as numeric or date/time.

Core Parameters

Core Parameters properties will be available to the visual for the following chart types:

Property Purpose Bar Pie/Donut Line XY
Show Title Allows user to specify title, using chart.xkcd font ✔️ ✔️ ✔️ ✔️
Title Title text (available if Show Title enabled) ✔️ ✔️ ✔️ ✔️
X-Label Label for X-Axis. Defaults to Category if empty ✔️ ✔️ ✔️
Y-Label Label for Y-Axis. Defaults to first Measure if empty ✔️ ✔️ ✔️

Chart Options

Chart Options properties will be available to the visual for the following chart types::

Property Purpose Bar Pie/Donut Line XY
X Tick Count The number of ticks to display on the x-axis. ✔️
Y Tick Count The number of ticks to display on the y-axis. ✔️ ️️✔️ ✔️
Legend Position Specifies where to place the legend. ️️✔️ ✔️ ✔️
Show Line Specifies whether lines should be connected with a line. ✔️
Time Format When the Category is Date/Time, you can provide a valid dayjs format specification to format the axis. ✔️
Dot Size Specifies size of the dots in the XY plot. ✔️
Inner Radius The radius of the chart (in %). Set this to 0% for a pie chart. ✔️

Support

The visual is an MIT-licensed open source project, provided "as-is" and funded entirely by my free time and my enthusiasm.

chart.xkcd is similarly-licensed and run, although Tim has a Patreon if you appreciate his work and want to support the development of chart.xkcd.

If there are bugs, then it's a good question as to whether they exist in chart.xkcd, or this custom visual's ability to drive it. Feel free to create issues and I will investigate when I can, advise accordingly (and possibly pass over the fence to the chart.xkcd project if needed).

Personally, this was an exercise for me in how the Custom Visuals SDK can drive another charting library, and there's some fun stuff going on under the hood. Some of the conditions that handle mapping into the view model are not optimal and will need to be revisited, I'm sure.

If you wish to learn more about how dataRoles and dataViewMappings work, as well as the code required to make a workable view model, then feel free to check-out, review and ask any questions. I'll do my best to answer them. I'd be happy if the visual can educate potential developers, as well as entertain ;)

Privacy Policy

This visual does not collect your data. Data is accessed for display purposes only.