topic Re: Pie Chart Interaction with Table Matrix & Clustered Column Chart in DAX Commands and Tips

Pie Chart Interaction with Table Matrix & Clustered Column Chart

Anonymous — Tue, 13 Dec 2022 09:47:57 GMT

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!

Re: Pie Chart Interaction with Table Matrix & Clustered Column Chart

amitchandak — Wed, 14 Dec 2022 03:28:32 GMT

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

Re: Pie Chart Interaction with Table Matrix & Clustered Column Chart

Anonymous — Wed, 14 Dec 2022 08:00:01 GMT

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!