Forum Discussion
Bali21
3 years agoFrequent 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 name | Loc ID | Manager 3 | Manager 2 | Manager1 |
| Rezza | 33 | John | Wade | Issac |
| Mark | 33 | John | Wade | Issac |
| Amy | 22 | John | Wade | Issac |
| Issac | 33 | John | Wade | |
| Wade | 77 | John | ||
| Dab | 444 | Leena | ||
| Evan | 333 | Leena | Dab | |
| lylla | 111 | Leena | Dab | Evan |
| Ray | 111 | Leena | Dab | Evan |
Table 2:
| Location Owner | Loc ID |
| Issac | 33 |
| Issac | 22 |
| Issac | 44 |
| Wade | 77 |
| Wade | 88 |
| John | 55 |
| John | 66 |
| John | 99 |
| Evan | 111 |
| Evan | 222 |
| Evan | 555 |
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:
- Criar uma tabela dimenção com os nomes unicos;
- Faça o relacionamento desta com as outras duas;
- Coloque esta terceira no filtro de página.
1 Reply
- VilmarSchPost Partisan
Veja se ajuda:
- Criar uma tabela dimenção com os nomes unicos;
- Faça o relacionamento desta com as outras duas;
- Coloque esta terceira no filtro de página.