10-28-2016 07:55 AM
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)
- 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 Repository
- Install the required R packages: VennDiagram
11-22-2016 02:44 AM
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.
03-21-2017 11:01 PM
01-16-2018 01:48 PM
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"))
01-25-2018 01:26 AM
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
01-25-2018 07:03 AM
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.