Visual Interactions on Pie Chart cancelling out

[kreese]

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.

[jpereztang · Accepted solution]

Hi @kreese

To reproduce your situation i use products, hierarchy i have is:

Marca > Linea > .... Producto

An image is worth a thousand words

beforeafter

Regards,

Jean Pierre.

Please click the Accept as Solution if this resolves your issue; if it did not resolve your issue, provide more information on what happened instead.

[v-qiuyu-msft]

Hi @kreese,

Would you mind using some sample data to indicate the issue then share sample .pbix with us? From the description, it's hard for us to reproduce in our environment.

Thanks for your understanding.

Best Regards,
Qiuyun Yu

[kreese]

Good Idea! I will put something together and post it.