Forum Discussion
Create connected 3 pie chart
Greeting, I want to create 3 charts that connects with each other, which it does currently. But there is one thing I want to improve on. When the first pie "Close" is selected, the second chart sh...
Hi Anonymous
Use Edit Interactions Carefully- Ensure Chart 1 (Status) filters both Chart 2 and Chart 3.
- Ensure Chart 2 (Discipline) only filters Chart 3.
- But Chart 2 should not override the Status filter — this is where the default behaviour may not suffice, hence the need for DAX-based control.
To keep the 2nd pie chart showing only the "Close" count for OCS when you select OCS, instead of changing to the total of Open and Close:
Create a measure for the 2nd pie chart that always filters for "Close" status, ignoring other statuses.
Use this measure in the 2nd pie chart instead of the default count or sum.
Keep the interaction filters as they are.
This way, when you select OCS in the 2nd pie, it still shows only the "Close" values for OCS, not the total.