Forum Discussion
How to use Plotly to create sankey chart
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
)
)- Anonymous7 years ago
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
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
5 Replies
- AnonymousNot applicable
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
- RogerSteinbergPost Patron
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?
- AnonymousNot applicable
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
- AnonymousNot applicable
RogerSteinberg , have you find a solution to generate sankey chart in powerBI service with R plotly? If yes, could you help share?