Hierarchy Chart

Hi JTucker,

I'm a little late to respond, but i think I'm tackling the same issue as you and I'm sure others will stumble upon your question and want a reasonable response.

I can't find any hierarchy visualisations created by Microsoft, however there are built in DAX functions for recursively building hierarchies and I believe the Akvelon hierarchy visual leverages those DAX functions.

To get either the DAX or the Akvelon visual working you'll need a table with a format like;

Part No | Parent Part No | Part Name | Part Type

You must have a single row for each Part No as a Part No can only have one parent, but a Parent Part No can appear multiple times as it can have multiple children.  The Part Name is your 'Title' in the Akvelon visual and 'Type' can be anything you want to dictate a colour scheme and legend.

Additionally, there must be a single root node with a Parent Part No of null, so for your application it might be some kind of artificial "Total System" part to bring the top level parts together.

eg; 

Part No | Parent Part No | Part Name                     | Part Type

0           |  null                  | Total System                  | Root Node

1           |  0                      | Parent Widget 1            | Parent Widget

2           |  0                      | Parent Widget 2            | Parent Widget

3           |  1                      | Child Widget 1              | Child Widget

4           |  1                      | Child Widget  2             | Child Widget

5           |  2                      | Child Widget 3              | Child Widget

You can find a working example here;

http://blog.pragmaticworks.com/power-bi-custom-visuals-hierarchy-chart-by-akvelon

Info on the DAX hierarchy functions is here;

http://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-child-functions-in-dax

Hope this helps.

Cara