How to add a custom filter to link tables

[Anonymous]

Hi,

I'm facing a problem of how to add a custom filter showing below to link tables.

Currently, I can add this kind of filters via built-in Q&A. But I can't modify it or create new like this to link tables. If I create a visual without this filter, it will show wrong data without the necessary link between the two tables (There is the relationship between two tables). 

Thanks,

[v-yuezhe-msft · Accepted solution]

@Anonymous,

When you change the cross filter direction from single to both between the two tables, the pie chart will show as the right pie chart.



Regards,
Lydia

[Seward12533]

Need more details can't tell what your tring to accomplish

[Anonymous]

Hi @Seward12533, 

Just like this two table:

 
In Table A, TableA.ID links to TableB.ID. Each entity has its own parent (Parent Name). 

What I want to do is to show a pie chart with parents and related number of TableB.Names. The column of Type would be used for the slicer.  
 

TableA				TableB
ID	EntityName	Parent Name		ID	Type	Name	Description	Description
1	AA	Parent A		1	Type A	Name A	data	data
1	BB	Parent A		2	Type A	Name B	data	data
1	CC	Parent B		3	Type A	Name C	data	data
1	DD	Parent B		4	Type A	Name D	data	data
2	AA	Parent A		5	Type A	Name E	data	data
3	AA	Parent A		6	Type B	Name F	data	data
4	BB	Parent A
5	CC	Parent B
6	DD	Parent B

However, I don't know how to create filters like this as showing in the screenshot. 

Many Thanks,

[v-yuezhe-msft · Accepted solution]

@Anonymous,

When you change the cross filter direction from single to both between the two tables, the pie chart will show as the right pie chart.



Regards,
Lydia

[Anonymous]

@v-yuezhe-msft Hi Lydia, Problem solved! Thanks for your help. 

@Seward12533 Yes, I did also struggle with this problem for a while.  Thanks for your tutorial. 

[Seward12533 · Accepted solution]

Thanks, I had no idea what he was asking. This is one of the reason I almost never connect fact tables directly. @Anonymous relationships and filter context is something I struggled with for a while when I was learning PowerBI. Here is a tutorial I put together you may find helpful especially as the bidirectional filtering using the both directions will not always work in complex models. https://filedrop.telusa.com/message/rbJ2yzoYSFn9Fr28FVTKsI