Using a filtered value for a pie graph

[Shackwell]

Hello mythical cybernetic creatures,

Im trying to make a more graphic report of a currently set of databases. Currently have the following tables,

budget vs actual = 1st column department, budget, actual budget,

and then I have another table where it shows the individual costs that make the expense for every department. Right now this table is showing all the individual costs of the departments together, but when I click upon a department in the first table it shows such portion of the data being highlighted. But what I want instead of the color highlight is it to make a whole new graph without having highlighted reference. So I want to have a full colored graph changing as I click through the departments, because right now it doesnt show the visual as intended. I will put in a screenshot of it. Thank you for you time, 

example

[v-rongtiep-msft]

Hi @Shackwell ,

Please try to use drillthrough. Please refer to the following document to see if it helps you.

https://docs.microsoft.com/power-bi/consumer/end-user-drill

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Shackwell]

Let me try both options gentlement and I will let you know. Thanks in advance for the help.

[MFelix]

Hi @Shackwell ,

This has to do with the options of interaction between visuals you can select highligh or filter.

Check the link for the documentation and select the filter option for that specific table/chart interaction.