Venn diagram

[Anonymous]

I hope someone can help me.  I have two Excel sheets, one contains a list of college courses offered for the year 2023, and the other contains a list of courses for the year 2024.  There are over 2,000 different courses.

I would like to create a Venn diagram as a visualisation to show the following:

Left circle of diagram shows the number of courses that were ONLY offered in 2023
Right circle of diagram shows the number of course that are ONLY being offered in 2024
The overlap between the two circles shows the courses that were offered for both 2023 AND 2024.

Once the Venn diagram has been created, I would like the tables to filter depending on what has been clicked in the diagram, i.e. if the intersection between the two circles is selected, the table should filter to list all the courses that were offered for 2023 AND 2024.

This sounds really simple, and I know exactly what I'm trying to achieve, but it's not proving to be simple at all.

Can anyone point me in the right direction please?

Many thanks,

Debbie

[Anonymous]

Thank you SO much - that seems to have done the trick.  The problem was that I didn't have the correct relationship between the tables.  I resolved the m:m relationship with a link table called "coursetitle".  Many thanks - I know what t do in the future.  🙂

[v-nuoc-msft · Accepted solution]

Hi @Anonymous 

To your question of creating a Venn diagram, it does seem to be somewhat challenging.

Based on the information you provided, you have two tables, course information for 2023 and 2024.

First you need to adjust the tables so they look like this:

Launch Power BI and select New Report from the Home tab.

Select the Venn Diagram visual from the Visualization pane on the right side of the window. If you don't see it, you may need to download it from the market.

Drag and drop the dataset into the appropriate field (usually labeled Category, Count, or Value).

Adjust the size and position of the circles as needed to create the desired overlaps and intersections.

Customize the colors and labels of your Venn diagram in Power BI using the Format tab on the right side of the window. You can also add interactivity and animation to your Venn diagram using the Animation and Interaction options under the Format tab.

To filter a table based on selections in a Venn diagram, you need to create a relationship between the table and the Venn diagram. To do this, go to the Modeling tab and select Manage Relationships. Then, create a new relationship between the table and the Venn diagram using a common field (such as course name or code).

Once the relationship is established, you can use the Edit Interaction options under the Format tab to control how the table is filtered when you click on the Venn diagram. You can choose to highlight, filter or cross-filter the table according to your preference.

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.