Visual Interactions on Pie Chart cancelling out

I have a dashboard created in Power BI that is meant to display the financial status of all project within out company. .

 

Bar Graph

Each project is labeled with a [Charge Code] on a bar graph to display dollars expended versus total budget.  This data is from a table called [PM Summary].

 

Pie Chart

This breaks down the [Cumulative Hours] for each [Charge Code] by what Division charged to that project

 

Data Table

Strictly for data view of hte actual individual charging to each project.

 

Interactions

When the bar graph is filtered, I have the pie chart and data table filtering also

When the pie chart is filtered, I have the bar graph doing nothing and hte data table filtering.

 

What I would like to be able to do it click a [Charge Code} within the bar graph and have the pie chart filter down to what [Division](s) are charging to it.  Once that filters, I would like to then be able to click one [Division] in the pie chart (for the [Charge Code] chosen on the bar graph) to determine (from the data table) who is charging to that [Charge Code] from the [Division] chosen from the pie chart.

 

What is happening right now is I click the [Charge Code] on the bar graph which filters the data table and the pie chart accurately.

However, when I go to the next step to click a specific [Division] on the pie chart, the bar graph filter is canceled out.  The interactions are not allowing me to drill down to that next step.

 

This is not a file I can share, because it holds extremely sensitive information.

 

Any feedback would be much appreciated.