Forum Discussion

Bali21's avatar
Bali21
Frequent Visitor
3 years ago
Solved

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:

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!

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

     

     

1 Reply

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