Forum Discussion

Kalachuchi's avatar
Kalachuchi
Helper III
5 years ago

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 Coun...
Need Help
Tutorial Requests
PC2790's avatar
PC2790
Community Champion
5 years ago

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's avatar
Kalachuchi
Helper III
5 years ago

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's avatar
    v-lionel-msft
    Community Support
    5 years ago

    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.