Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Venn diagram

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

1 ACCEPTED SOLUTION
v-nuoc-msft
Community Support
Community Support

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:

 

vnuocmsft_1-1708394892237.png

 

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).

 

vnuocmsft_3-1708395031808.png

 

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.

 

vnuocmsft_4-1708395116060.png

 

Regards,

Nono Chen

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

 

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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
Community Support
Community Support

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:

 

vnuocmsft_1-1708394892237.png

 

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).

 

vnuocmsft_3-1708395031808.png

 

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.

 

vnuocmsft_4-1708395116060.png

 

Regards,

Nono Chen

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

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors