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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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 Patron
Post Patron

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 Patron
Post Patron

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.