How to use Plotly to create sankey chart

[RogerSteinberg]

I am trying to bypass the sankey chart from the marketplace because it is very flawed.

So, I am trying to create my chart using the R script visual from the Visualizations Panel. However, it appears using plotly with sankey doesnt work. Here's a sample of the R script:

library(plotly)

p <- plot_ly(
    type = "sankey",
    orientation = "h",

    node = list(
      label = c("A1", "A2", "B1", "B2", "C1", "C2"),
      color = c("blue", "blue", "blue", "blue", "blue", "blue"),
      pad = 15,
      thickness = 20,
      line = list(
        color = "black",
        width = 0.5
      )
    ),

    link = list(
      source = c(0,1,0,2,3,3),
      target = c(2,3,3,4,4,5),
      value =  c(8,4,2,8,4,2)
    )
  ) %>% 
  layout(
    title = "Basic Sankey Diagram",
    font = list(
      size = 10
    )
)

[v-shex-msft · Accepted solution]

Hi @RogerSteinberg,

Actually, It seems like also not works on power bi side. When I test with r studio, it works well...
Have you test to use records from dataframe which you dragged to r script value fields to create other graph?

Regards,

Xiaoxin Sheng

[Anonymous]

@RogerSteinberg , have you find a solution to generate sankey chart in powerBI service with R plotly? If yes, could you help share?

[v-shex-msft]

Hi @RogerSteinberg,

>>However, it appears using plotly with sankey doesnt work. Here's a sample of the R script:
Did you means use sankey graph to interaction with other visuals? If this is a case, current r visual graph can't interact with other visual, it can be affected by other visual or filters.

You can also take a look at following link about use r visual to draw sankey graph:

Creating Custom Sankey Diagrams Using R

Regards,

Xiaoxin Sheng

[RogerSteinberg]

Hi XiaoXin,

So if I understand correctly, I could apply the logic of your link to create a sankey chart using the R visual within Power Bi?

[v-shex-msft · Accepted solution]

Hi @RogerSteinberg,

Actually, It seems like also not works on power bi side. When I test with r studio, it works well...
Have you test to use records from dataframe which you dragged to r script value fields to create other graph?

Regards,

Xiaoxin Sheng

[RogerSteinberg · Accepted solution]

The problem is that I only want this graph for the purpose of my project. But I guess I'll wait for furture updates.

Thank you