Venn Diagram

Hi Anonymous, 

I am glad it worked out for you. Here are limitations of R visuals in PBI: 
https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals#known-limitations

Thank you so much!!!

This visual appears to give incorrect results when 4 fields are selected.

I can do 3 just fine but 4 doesn't calculate properly, e.g., a category with 30 items shows 20, 4, 0, 0 instead of adding to 30.

My math could be off, though. I think with 4 categories there's no way to actually show the top & bottom categories (or left & right) intersecting since they already overlap in the middle.  Maybe that's just a limitation of Venn diagrams; in that case maybe limit it to 3 categories?

3 categories: correct figures; each category adds to 8.4 categories: Something is wrong; categories add to 7.

Data is standard 4 variable w/ 2 options per variable.

Hi spotpuff, 

Please make sure all the rows in your input table are UNIQUE. You can do it by adding ID column (but ignore it in R script). 

The rows are unique; I was using an illustrative example but I was using the diagram on a real dataset which has a row ID type field and I was still having problems with the 4 dimensional Venn diagram.

The issue is likely something to do with more than 3 categories requiring strange diagrams:

https://en.wikipedia.org/wiki/Venn_diagram#Extensions_to_higher_numbers_of_sets

The visual doesn't make the 4th category into that "rainbow" type thing, so the math might be off.

Or I might be wrong.

Either way for now I'm sticking with 3 categories as the math works out in that diagram.

Hi spotpuff

The code uses the VennDiagram package, check their documentation. 

Can I get the PBIX with exact R code and data which you use for testing ?