Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Pie Chart Interaction with Table Matrix & Clustered Column Chart

Hey guys, 

 

I have a unusual issue. 

 

I have 3 visuals on my dashboard that I expect to interact both ways. They use the data from the same table and it's structured like this: 

 

Month / Term Reason / Total Terminations / 0-30 Days Term / 31-60 Days Term / 61-90 Days Term / etc. 

1/1/2022 / New Career Opportunity / 10 / 5 / 3 / 2 

1/2/2022 / Health Related / 12 / 5 / 5 / 2 

etc. 

 

Now... when I click on the Matrix or the Clustered Column Chart, the Pie Chart is reacting properly. 

 

 

But what I need is to look at the reasons for each tenure bucket so when I click on the pie chart on 0-30 Days, I expect the Matrix and Clustered Column chart to show me the 7 people and their Termination Reason, but this doesn't happen, it doesn't interact at all with the other visuals: 

 

 

Any ideas what is wrong? 

 

Please let me know if I need to provide more information. 


Thank you!

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , If the measure is using userelationship, then it needs to present in visual to filter data

     

    seem like the same as drill thorough issue

     

    Power BI Drill Through when Userelationship is used: https://youtu.be/1BM_WGATrQA

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      hi amitchandak, there are no measures, only column data is being used in all visuals. 

      Not sure why they interact on one way and not the other. 

      Also I checked the "Edit Interactions" and they are ok by default, I didn't change anything there. 

       

      Thank you!