Power BI report having multiple tables where relationship exists

[Sushil1]

I am new to Power BI Desktop but familiar with data relationship. My problem scenario is that I have 3 tables Events, Participants, and Participant Details.

Table 1 – Events

Event Id
Event Name
Event Type

Table 2 – Participants (there are many participants for a event)

Event Id
Participant Id

Table 3 – Participant Details

Participant Id
Participant Name
Participant Gender
Participant Country

My need is how do I get a visual showing Gender or Country Disaggregation (the data is in Table 3) when I select an event from Table 1. Do I need to join the table or what is the step to prepare the data first and then the visual. Guidance much appreciated.

[audreygerred · Accepted solution]

Hello - you would join your tables like I have below:

Then, when you make your visual, you can put name, gender, and country in from your participants detail table and put participant ID in from the participants table. Next, add the Event name or Event ID field and or type from the Event table to the filters on this page or filters on all pages in the filter pane. In my example, I just did the name.

Here, we can see all 6 participants that I have created are showing because I do not have anything filtered:

Now, if I filter to a specific event, only the people who attended appear:

Ditto for if I choose an event type:

Hope this helps!

[Sushil1]

Thank you so much and for a quick reply! The trick seemed creating the right relationship among tables and your relationship diagram with sample data helped me to quickly understand. Much appreciated!

[audreygerred]

You are very welcome! Happy to help!