How to stop specific row in matrix interacting with other chart

[taeyang]

Hi, I have two visuals with interactions; 1) KPI Overview Matrix and 2) Average Selling Price.

And would like to stop interaction of KPI from 1) Matrix with specific Chart 2) Average Selling Price.

For example, if I select the product A from Matrix 1), I wish ASP for the product A appears  in chart 2).

However, if I select product in Matrix 1), it automatically selects KPI as well and make Average Selling Price calculation invalid.

1) KPI Overview consists of two levels of Rows. First Level is KPI itself (i.e. Sales, Volume, Margin) and second level is product.

2) Average Selling Price is Calculated measure using the Sum of KPI (Calculate + filter).

Since 2) Average Selling Price is calculated by dividing Sales Performance by Volume, any selection in Matrix 1) returns invalid result in Chart 2).  As soon as KPI is filtered in Matrix 1), it makes my ASP calculation invalid.

In conclusion I wish interaction only works for products, not KPI in the rows of the matrix table. How can I do this ?

[v-binbinyu-msft · Accepted solution]

Hi @taeyang ,

As far as I know, currently in Power BI you can only control whether two visual objects can interact with each other, not exactly which line.

Best regards,
Community Support Team_ Binbin Yu