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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Bali21
Frequent Visitor

Filters are not working - same filter for two table

I have two data source which i combine with Full join on (Loc ID) and I want to use single filter for both the table BUT filter are showing wrong numbers for viz 1 as 3 required filter are coming from Table 2. I need to get the correct number for viz 1(decomposition tree) as well. Any much help appreciated!!

Table 1:

EMP nameLoc IDManager 3Manager 2Manager1
Rezza33JohnWadeIssac
Mark33JohnWadeIssac
Amy22JohnWadeIssac
Issac33JohnWade 
Wade77John  
Dab444Leena  
Evan333LeenaDab 
lylla111LeenaDabEvan
Ray111LeenaDabEvan

 

Table 2:

Location OwnerLoc ID
Issac33
Issac22
Issac44
Wade77
Wade88
John55
John66
John99
Evan111
Evan222
Evan555

 

ScreenShot of PBI without filter:

Bali21_0-1685735011751.png

Once filter is applied Viz 1 not changing, it only applicable to table viz. Could you please suggest how it can be achived. So If I select "Issac" then both viz should be changes as per selection with correct count in Viz one as well.

 

Thank in Advance!

1 ACCEPTED SOLUTION
VilmarSch
Post Partisan
Post Partisan

Veja se ajuda:

  1. Criar uma tabela dimenção com os nomes unicos;
  2. Faça o relacionamento desta com as outras duas;
  3. Coloque esta terceira no filtro de página.

 

 

Wp4xGF6XHa.gif

View solution in original post

1 REPLY 1
VilmarSch
Post Partisan
Post Partisan

Veja se ajuda:

  1. Criar uma tabela dimenção com os nomes unicos;
  2. Faça o relacionamento desta com as outras duas;
  3. Coloque esta terceira no filtro de página.

 

 

Wp4xGF6XHa.gif

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors