Help Needed: Creating Sankey Diagram using D3 Visualization

[TeddyH]

I am attempting to create a sankey diagram using D3 visualization. I would like to know how do you take the dataset embeded in the javascript (in json as nodes and links) and recreate it as an external tsv file so that I can use the pbi.dsv() function to connect the D3 visual to the dataset in the report

var margin = {top: 1, right: 1, bottom: 6, left: 1},
    width =  pbi.width - margin.left - margin.right,
    height =  pbi.width - margin.top - margin.bottom;

var formatNumber = d3.format(",.0f"),
    format = function(d) { return formatNumber(d) + " tuples"; },
    color = d3.scale.category20();

var svg = d3.select("#chart")
    .attr("width", width + margin.left + margin.right)
    .attr("height", height + margin.top + margin.bottom)
  .append("g")
    .attr("transform", "translate(" + margin.left + "," + margin.top + ")");

var sankey = d3.sankey()
    .nodeWidth(15)
    .nodePadding(10)
    .size([width, height]);

var path = sankey.link();

function createChart( energy ) {
  sankey
      .nodes(energy.nodes)
      .links(energy.links)
      .layout(32);

  var link = svg.append("g").selectAll(".link")
      .data(energy.links)
    .enter().append("path")
      .attr("class", function(d) { return (d.causesCycle ? "cycleLink" : "link") })
      .attr("d", path)
      .style("stroke-width", function(d) { return Math.max(1, d.dy); })
      .sort(function(a, b) { return b.dy - a.dy; });

  link.append("title")
      .text(function(d) { return d.source.name + " -> " + d.target.name + "\n" + format(d.value); });

  var node = svg.append("g").selectAll(".node")
      .data(energy.nodes)
    .enter().append("g")
      .attr("class", "node")
      .attr("transform", function(d) { return "translate(" + d.x + "," + d.y + ")"; })
    .call(d3.behavior.drag()
      .origin(function(d) { return d; })
      .on("dragstart", function() { this.parentNode.appendChild(this); })
      .on("drag", dragmove));

  node.append("rect")
      .attr("height", function(d) { return d.dy; })
      .attr("width", sankey.nodeWidth())
      .style("fill", function(d) { return d.color = color(d.name.replace(/ .*/, "")); })
      .style("stroke", function(d) { return d3.rgb(d.color).darker(2); })
    .append("title")
      .text(function(d) { return d.name + "\n" + format(d.value); });

  node.append("text")
      .attr("x", -6)
      .attr("y", function(d) { return d.dy / 2; })
      .attr("dy", ".35em")
      .attr("text-anchor", "end")
      .attr("transform", null)
      .text(function(d) { return d.name; })
    .filter(function(d) { return d.x < width / 2; })
      .attr("x", 6 + sankey.nodeWidth())
      .attr("text-anchor", "start");

  function dragmove(d) {
    d3.select(this).attr("transform", "translate(" + d.x + "," + (d.y = Math.max(0, Math.min(height - d.dy, d3.event.y))) + ")");
    sankey.relayout();
    link.attr("d", path);
  }
  
};


var energyData = {"nodes":[
{"name":"A"},
{"name":"B"},
{"name":"C"},
{"name":"D"},
{"name":"E"},
{"name":"F"},
{"name":"G"},
],
"links":[
{"source":0,"target":1,"value":2},
{"source":1,"target":2,"value":4},
{"source":2,"target":3,"value":30},
{"source":2,"target":1,"value":5}, // Looper
{"source":4,"target":2,"value":5},
{"source":4,"target":5,"value":5},
{"source":5,"target":6,"value":5}
]}

createChart( energyData )

[Anonymous]

Hi @TeddyH could you solve it? I'm trying to use the D3.js sankey graph in power bi and I'm getting a whyte report.

[v-viig]

To understand how to do so we would recommend to go through these resources:

1. https://microsoft.github.io/PowerBI-visuals/docs/overview/
2. https://github.com/Microsoft/powerbi-visuals-sankey/blob/master/src/visual.ts#L321

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com