Forum Discussion
Can't join to third table
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.
4 Replies
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.
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.
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 🙂
