Decomposition tree sample visual fitting

Question

Here is a sample provided by Davide Bacci:

I would like to use this template for my .pbix file; however, it's not working as expected. In Davide's example, the datasource is a JSON, whereas I have a Power BI dataset. I need to replicate a similar structure, especially the first line (Max Armstrong), to make it work.

Here is a sample of my data structure: https://github.com/tomecsek21/pbix_file

The visual should begin with a node representing total revenues, and then it should be divided into sublevels. Nodes should always be sorted based on revenues, from highest to lowest.

Answer 1

You have multiple roots and a tree works from a single root. To keep this simple, rename your columns as follows:

Add them to a Deneb visual but put a filter on so you only see a single root:

In the spec, overwrite source with the following:

 {
  "name": "dataset"
},
{
  "name": "source",
   "source": "dataset"
},

Change the domain to the following (my kpis were percentages hence the hard coded 0-100):

{
      "name": "kpiscale",
      "zero": false,
      "domain": [0, 1800],
      "range": {"signal": "[0,scaledNodeWidth]"}
    },

That should be enough for you to restructure your data but if you add more levels, you will need to update the Vega.