jessicammoss's avatar
jessicammoss
Advocate I
9 years ago

Venn Diagram

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 ...
General R Visualizations
Anonymous's avatar
Anonymous
Not applicable
8 years ago

When I click on your link,  AttachmentVennDiagramWithR.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's avatar
    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's avatar
      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.

      • boefraty's avatar
        boefraty
        Microsoft Employee
        8 years ago

        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.