cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
drewmcspy
Frequent Visitor

Use Filter or Single Selection to show all related data in parent group

Hi

 

The below table is a fictional list of cities, people and age.

 

CityNameAge
LiverpoolTom30
LiverpoolJill15
LiverpoolJim26
LiverpoolSophie32
LiverpoolLynsey20
LiverpoolHelen33
LiverpoolMary20
LiverpoolJen31
New YorkHelen22
New YorkMary15
New YorkTom24
New YorkJon26
La PazBren24
La PazMel33
La PazHelen25
La PazRuby22
La PazJim20
BeijingJill29
FreetownBren30
DurbanSarah16
DurbanSophie30
MadridJill16
MadridTom31
MadridMary15
MadridHelen24
MadridJon28
MadridMark30

 

What I'm hoping to do is, when a name is selected, it Power BI will show all groups they belong to and all other members of the groups, including their ages. 

 

Examples

 

If Tom is Selected

 

CityNameAge
LiverpoolTom30
LiverpoolJill15
LiverpoolJim26
LiverpoolJon32
LiverpoolLynsey20
LiverpoolHelen33
LiverpoolMary20
LiverpoolJen31
New YorkHelen22
New YorkMary15
New YorkTom24
New YorkJon26
MadridJill16
MadridTom31
MadridMary15
MadridHelen24
MadridJon28
MadridMark30

 

If Jill is Selected

 

CityNameAge
LiverpoolTom30
LiverpoolJill15
LiverpoolJim26
LiverpoolJon32
LiverpoolLynsey20
LiverpoolHelen33
LiverpoolMary20
LiverpoolJen31
BeijingJill29
MadridJill16
MadridTom31
MadridMary15
MadridHelen24
MadridJon28
MadridMark30

 

If Sophie is Selected

 

CityNameAge
DurbanSarah16
DurbanSophie30

 

I hope that makes sense and hope it's achievable.

 

Thanks in advance.

 

mcspy

1 ACCEPTED SOLUTION
barritown
Super User
Super User

Hi @drewmcspy

If by groups you mean cities and your dataset is relatively small, you could use such a solution:

1) Create a full copy of your table.

2) Link the original table and the duplicate via [City] (many-to-many).

3) In the slicer, you could use the duplicate table, in the table visual - the orinal one.

BTW, the "Sophie" test case is not quite correct - there is another Sophie in Liverpool.

 

Here is the scheme:

barritown_0-1688031066241.png

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

View solution in original post

2 REPLIES 2
barritown
Super User
Super User

Hi @drewmcspy

If by groups you mean cities and your dataset is relatively small, you could use such a solution:

1) Create a full copy of your table.

2) Link the original table and the duplicate via [City] (many-to-many).

3) In the slicer, you could use the duplicate table, in the table visual - the orinal one.

BTW, the "Sophie" test case is not quite correct - there is another Sophie in Liverpool.

 

Here is the scheme:

barritown_0-1688031066241.png

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

Exactly what I needed, thanks

(completely right about Sophie too 😀)

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors