Can't join to third table

[Kalachuchi]

Hello guys, 

my detail table and summary table and Region/Country table is doing well but when I use filter from another table, it doesnt work.

Detail Table:

UniqueID	Status	Region	DoP	Country	Peripherals	Brand	Remarks
1	New	APAC	2019	AU	Keyboard	Razer	Working
2	Old	ASEAN	2019	SG	Mouse	Logitech	Not Working
3	New	APAC	2019	NZ	Headset	Steelseries	Not Working

Summary

UniqueID	Region	DoP	Country	New	Old
1	APAC	2019	AU	1	0
2	APAC	2019	NZ	1	0
3	ASEAN	2019	SG	0	1

Region/Country

UniqueID	Region	Country
1	APAC	AU
2	APAC	NZ
3	ASEAN	SG

My Barchart will show Summary and table below will be Detail. Slicer will be between Region and Country

X axis will be Dop, value will be the number of new and old on summary. 

[Fowmy]

@Kalachuchi 

Hope you have created the correct relationships between the tables. If not please refer to: https://www.youtube.com/watch?v=-4ybWQSRcOY

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[PC2790]

Hi @Kalachuchi ,

If you are saying that the slicer selection from Region and Country doesn't work. Please check a couple of things:

1) Edit interactions. Related article here

2) The relationships between the Region/Country with other tables

3) If the relationship is all fine, please check the filter direction as well

If none of these work, please share your pbix to further look into it.

[Kalachuchi]

@PC2790 

The filters actually work

Problem is when I clicked the orange box on the bar chart it doesnt give me new details on my table below. it doesn't filter since there is no active relationship between the two.

[v-lionel-msft]

Hi @Kalachuchi ,

“Problem is when I clicked the orange box on the bar chart it doesnt give me new details on my table below.”

When you click the orange box, the corresponding X axis is actually filtered. The current version has no way to filter the orange boxes individually.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.