Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

[need help] Error occurs when creating Sankey diagram by R script

Hi Team,

I did data transform by creating a new table with DAX, and the format of new table is sankey format: Source, Target, Occurs(Please refer to below table1)

Table1:

sankeytable.jpg

Then I trying to create sankey diagram with R visulization, here is the script:

 

# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script:
 
dataset <- data.frame(Source, Target, Occurs)
dataset <- unique(dataset)
library(networkD3)
dataset$Source = as.character(dataset$Source)
dataset$Target = as.character(dataset$Target)
Sankeylinks<-dataset
Sankeynodes<-data.frame(name=unique(c(Sankeylinks$Source,Sankeylinks$Target)))
Sankeynodes$index<-0: (nrow(Sankeynodes) - 1)
Sankeylinks<-merge(Sankeylinks,Sankeynodes,by.x="Source",by.y="name")
Sankeylinks<-merge(Sankeylinks,Sankeynodes,by.x="Target",by.y="name")
Sankeydata<-Sankeylinks[,c(4,5,3)];
names(Sankeydata)<-c("Source","Target","Occurs")
Sankeyname<-Sankeynodes[,1,drop=FALSE]
# draw sankey network
sankeyNetwork(Links=Sankeydata,Nodes=Sankeyname,Source="Source",Target="Target",Value="Occurs",NodeId="name",fontsize=8,nodeWidth=20)
But there is error occured.
error.jpg
 
what is the issue with my script?
1 REPLY 1
v-evelk
Employee
Employee

Hi,

 

The error on your picture says that field name is unavailable.

Please check that you correctly typed all your fileds names.

Also, pay attention please that using fileds must be added to "Values" bucket to be available in a script regarding this article.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors