Venn diagrams show overlapping regions based on values within sets. The R visualization code provided in this Power BI desktop file will take a dynamic set of columns (based on the values you add in the fields pane), perform the overlap analysis, and display the diagram. This code will work with up to 5 columns. Prerequisites (The sample .pbix files will not work without these prerequites completed)Install R Engine: Power BI Desktop does not include, deploy or install the R engine. To run R scripts in Power BI Desktop, you must separately install R on your local computer. You can download and install R for free from many locations, including the Revolution Open download page, and the CRAN RepositoryInstall the required R packages: VennDiagram

PBIX is an extension of file generated in PBI desktop . If you send it to me I will have no trouble to reproduce your problem on my side.

Try changing parameters of venn.diagram For example margin: venndiagram <- venn.diagram(listdataset, filename=NULL, na="remove", fill = listcolor, margin = 0.1)

Hi Anonymous , I opened the attached PBIX it works fine for me. 1) Make sure you have updated PBI desktop 2) Install install.packages("VennDiagram") from your R IDE 3) If problem persisits look at the Error (See Details) 4) You may debug the code in your R IDE from R Visual 5) If your problem persisits send me your PBIX boefraty at microsoft com

Try to change your R visual to "Table" visual. See how it responses to slicer. OR Run the code with your filtered data in R IDE like RStudio (see my previous reply) and debug it OR Send me the PBIX :)

You are reading input from exel file, ignoring the input from PBI report :) #Comment out this line #Venn <- read.xlsx("Venn.xlsx", sheetName = "Venn", header = TRUE, stringsAsFactors = FALSE) #Use this one instead Venn = dataset I'd also recommend to clean the R code from loading unnecessary libraries (rJava etc.) Good luck with your project :)

Venn Diagram | Microsoft Fabric Community

29 Replies

boefraty
Microsoft Employee
9 years ago
Hi Jessica,

Thanks for this wonderful R-showcase. If you consider to convert this or one of your future R-visuals to R-powered-custom visuals, out team will be happy to assist you.

The visibility of R-powered custom visuals is greater and it is not limited for R-users.
fajarberlian
New Member
9 years ago
How can i create venn diagram without using R? Please help me
mark_phen
New Member
9 years ago
Hi Jessica,

Thank you for the R script.

However, for my requirement when I add a 5th column, the labels get truncated. Do you have any suggestion so as to how we can overcome that?

I've attached your file with my modifications to show you the problem I'm facing.

Thanks
Mark
VennDiagramWithR.pbix196 KB
- boefraty
  Microsoft Employee
  9 years ago
  Try changing parameters of
  
  venn.diagram
  
  For example margin:
  
  venndiagram <- venn.diagram(listdataset, filename=NULL, na="remove", fill = listcolor, margin = 0.1)
  - mark_phen
    New Member
    9 years ago
    Thanks!
Anonymous
Not applicable
8 years ago
When I click on your link, VennDiagramWithR.pbix, Power bi pops up with an error message. Can't see your code. (see attached screenshot) Does this still work or am I just doing it wrong? I wrote code in r that runs beautifully (in r). When I run it inn Power Bi, it gives me the same error message as I get when I click on your link.

Any hints anyone?

Here's my code and a screenshot of a small dataset (Venn_dummy)

draw.triple.venn(area1 = nrow(subset(Venn_dummy, Felony == "Yes")), area2 = nrow(subset(Venn_dummy, Misdemeanor == "Yes")), area3 = nrow(subset(Venn_dummy, Ordinance == "Yes")),
n12 = nrow(subset(Venn_dummy, Felony == "Yes" & Misdemeanor == "Yes")), n23 = nrow(subset(Venn_dummy, Misdemeanor == "Yes" & Ordinance == "Yes")),
n13 = nrow(subset(Venn, Felony == "Yes" & Ordinance == "Yes")), n123 = nrow(subset(Venn, Felony == "Yes" & Misdemeanor == "Yes" & Ordinance == "Yes")),
category = c("Felony Offenders", "Misdemeanor Offenders", "Ordinance Offenders"), lty = "blank", fill = brewer.pal(n = 3, name = "Dark2"))
- boefraty
  Microsoft Employee
  8 years ago
  Hi Anonymous , I opened the attached PBIX it works fine for me.
  
  1) Make sure you have updated PBI desktop
  
  2) Install install.packages("VennDiagram") from your R IDE
  
  3) If problem persisits look at the Error (See Details)
  
  4) You may debug the code in your R IDE from R Visual
  
  5) If your problem persisits send me your PBIX
  boefraty at microsoft com
  - Anonymous
    Not applicable
    8 years ago
    Hi Boefraty,
    
    Thank you for your helpful message.
    
    I got the Venn Diagram to work in Power Bi, but I can’t get the slicer to work with it. I’m supposed to do a demonstration on this next week (yikes). I’ve attached a screen shot. Can you give me any tips?
    
    Note: my data file has person-level data (not aggregate), and includes both charge data and demographic data (i.e. race).
    
    Also, I don’t know what a BPIX is.