Overlapping Chart or Venn diagram

[vin26]

Hello,

I have a requirement to create Overlapping Chart or Venn diagram, something similar to below visualization:

Sample data:

Category 1	Value	Category 2
A	1	B
B	2	C
C	3	E
D	4	D
E	5	A
A	6	E
B	7	A
C	8	C
D	9	D
E	10	B
A	11	C
B	12	D
C	13	B
D	14	A
E	15	E
A	16	B
B	17	D
C	18	A
D	19	E
E	20	C

Please suggest me any alternative visualization to represent the data similar to venn diagram.

[Anonymous]

HI @vin26 

Use the below visual 

[vin26]

Hi @Anonymous thanks for the suggestions, both the visuals will not work for my requirements, 1st one allows on only 4 items in a category and each of the item in category 2 should be in each columns, my data format will not work here.

[mhossain]

@vin26 

Try to change the structure your data, probably Pivot the data and @Anonymous 's suggested custom visual should work.

[vin26]

Hi @mhossain it allows maximum 4 categories and it works are yes/no or 1/0 format of data

[v-easonf-msft]

Hi , @vin26 

After researching, I can't find more custom visuals that meet your requirements in App Source. Most of these custom visuals cannot directly process the data template you provide, nor can they display so many categories.

Current visual  "Venn Diagram by MAQ Software"  allows up to 4 categories and can only show 13 possible combinations.

You can take  a try to  create a custom Venn chart by combining multiple pie charts.

Please  check if this video help . _Power BI - Creating a Custom Venn Diagram

Certainly, if you have enough ability, you can also create custom visuals using R and Python.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vin26 · Accepted solution]

Hi @v-easonf-msft many thanks for your effort and research. The screenshot attached at the beginning of the thread has done in R, it works fine, but there are some organizational restrictions to publish the report. Another visual called 'Ultimate Venn Diagram' works fine for my requirement, since this visual is not certified by Microsoft and also there is not option to purchase the licence, I need to drop the plan to use this visual. Thanks again.