How to prevent certain visuals in a page from being filtered?

[KY_13]

Hi Everyone,

I have a report where there are two tables which I do not want to be filtered when drill through from another page.
The slicer that i have is based on "Customer Name" and I have drill through the page through "Customer Name" itself.

And the two tables also shared "Customer Name" on the column.
This is the page below:

I noticed that the other visuals also have "customer name" as drill through option even though "customer name" is not an attribute in the visuals. I'm guessing because my values are derived from data which has a relationship with the "customer name" table.


I previously saw a suggestion to create another set of "customer name" data. I have duplicated another "customer name_copy" column and have used this "copy" as the column attribute for my tables. But the drill through option is still there.
Can anyone advise is there any workaround this?

Thank you.

[v-xiaotang]

Hi @KY_13 

Please try this, Change how visuals interact in a report - Power BI | Microsoft Learn

Change the interaction behavior

Best Regards,

Community Support Team _Tang

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