10-28-2016 07:55 AM
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)
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.
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.
When I click on your link,
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"))
Hi @juniper , 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
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.