Check out my previous post to see the streamgraph chart comparison.
In this post, I have taken Sankey chart custom visual. The power bi custom visual has less functionality compare than R visuals
Power BI Desktop
We have a Sankey chart custom visual available in Power BI. Download and import into Power BI Desktop.
Here I used a dataset called Titanic. This is one of the datasets in R which I used for this post.
To get the sankey visual, we need to install the alluvial package.
Run the below script in R Studio or R console application.
tit <- as.data.frame(Titanic)
alluvial( tit[,1:4], freq=tit$Freq, border=NA,
hide = tit$Freq < quantile(tit$Freq, .50),
col=ifelse( tit$Survived == “No”, “red”, “yellow”) )
|Power BI Desktop||R Studio|
|Import Sankey Chart visual||Install alluvial and related packages|
|Less Functionality||More Functionality|
|GUI Type||R Script Type|
|Only 2 levels of visual by default for the simple dataset. To see multi-level visuals then need to prepare a dataset with multi-level of source and destinations||Multi-Levels of visual – Just add the number of fields.|