How to avoid changes on total, when activating interaction filter.

[Anonymous]

Hello every body,

We have an issue, in one of the visuals (Visual #1) we have a count of product filter by category 1 and 2, and in the other visuals they have the count of product of all the categories, the problem is when interacting with visual #1, the other visuals total changes to a count of product by fitlering to category 1,2.  We already try "calculate" with "all" function, but it's not working, the only thing I can think of is to cancel the interaction, but we do want the report to be dynamic.

Any help on how to resolve this will be much appreciated.

Example filter with slicer.

Example filter with interaction of visual #1.

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

I think if "Total of product, category1,2 bar chart" is filtered category1,2 by visual level filter.

So when you do interaction, it will also interact with other visual by setting in visual level filter.

And you could try to use a measure like this:

Measure = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Cate]="C1"||'Table'[Cate]="C2"))

here is a similar post for you refer to:

https://community.powerbi.com/t5/Desktop/Ignoring-a-visual-level-filter-from-a-matrix-in-a-pie-chart/m-p/676598#M325698

If not your case, please share your simple sample pbix file.

Best Regards,

Lin