Clicking on one column value in matrix interacts with one visual.

[puneethjp]

Hi, 

We have a matrix table with three columns as shown below. We have two visuals a bar chart and a line chart. Every time the client clicks on any values under "Actuals": the bar chart and line chart should change/interact. Simlarly, 

Every time the client clicks on values under Delta, only the bar should interact, the line chart should stay constant.

Note: The bar chart on clicking delta value is different(another) from the bar chart appeaering when clicked on Actuals. We may consider another page for the second bar chart if it is feseable solution.  We already tried Edit interactions. It does not help here, since it not a visual to visual interation. 

Thanks

Puneeth

[Ritaf1983 · Accepted solution]

Hi @puneethjp 
I am not sure that I understood the request, but the logic of interaction from the table is that it filters only on the category level, in your scenario, it can be by KPI, not by actuals/delta.

If you use a matrix it works with the same logic, if your columns are categories from the table ( you have in data table columns for actual and delta and put them as a column on the matrix ( not measures) the interaction will work if not - not.

The functionality of appear/disappear visuals is possible with bookmarks, but this needs "buttons"  , like on this link:
https://www.aerieconsulting.com/blog/how-to-hide-and-show-visuals-in-power-bi

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

[puneethjp]

Thank you for your help @Ritaf1983 The client has added  few more changes. Will post it shortly. Thank you aginn.