Switching graphs based on the selections on another graph

[radu_1998]

Hi, I have two graphs on my dashboard, a pie chart and a bar chart. The pie chart essentially looks at sales by categories. The bar chart displays sales by different locations. Everytime the user selects a category on the pie chart, I want the bar chart to switch into a breakdown of the different subcategories within the selected category by sales. When nothing is selected I need the graph to return to the standard sales by location. However I have no idea how to do this, I think it's somethting to do with changing filter contexts but i'm really stuck atm.

Example output:

if nothing selected: bar chart shows sales by location

if category 1 of pie chart is clicked: bar chart shows all of the sub-categories contained within category 1 and the breakdown of sales per each sub category.

If category 2 of pie chart is selected:  bar chart shows all of the sub-categories contained within category 2 and the breakdown of sales per each sub category.

Thanks for your help in advance!

[Ritaf1983 · Accepted solution]

Hi  @radu_1998 
if I understood you correctly and you need one graph filtering another make it drill down we don't have this functionality.
If the bar graph graph is expended and the pie just needs to filter it then you can modify this option from "edit interactions"pbix with my example is attached.

More information about edit interactions is here :

https://www.youtube.com/watch?v=ENuG2F-tce0

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