Button Should only interact with one visual

[hmeltonPSL]

I have 2 table visuals.  One with completed workorders by technician and another with open workorders by technician.

I created an drilldown button for the Open workorders table.  I want it to only interact with the open workorders table however, it is also filtering when oicking a technican in the closed workorders table.  I turned off interactions but it is still drilling down.  Is there any way to make the button only interact with the open workorders table visual?

Thank you

[Sergii24 · Accepted solution]

Hi @hmeltonPSL, have you tried the "Edit Interactions" setting? Change how visuals interact in a report - Power BI | Microsoft Learn

I don't think there is a way to condittionally disable a button. You can play around with visual properties to make it invisible or change text when value from the wrong table is selected.

Alternatively, you can create a border that combines together the button with the right table, so users see the related items. It won't prevent them from clicking on it when wrong table is filtered, but will help those who want to get a necessary result rather focus on bugs 🙂

Good luck with your ptoject!

[v-kpoloju-msft · Accepted solution]

Hi @hmeltonPSL,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to @Sergii24, for his inputs on this thread.

I understand you would like the drill button to only interact with the Open Work Orders visual. Since Power BI buttons respond to the overall filter context, disabling visual interactions alone will not fully isolate them. You can try setting “Apply drill down filters to → This visual only” and verify that cross-filtering is turned off. Optionally, use a DAX measure to enable the button only when a technician is selected from the Open table.

Please note that Power BI currently does not provide a full way to restrict button or drill through actions to a single visual these steps should minimize, but might not completely remove, cross-context behaviour.

Refer this link: https://learn.microsoft.com/en-in/power-bi/create-reports/service-reports-visual-interactions?tabs=p... 

Hope this helps. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

[v-kpoloju-msft]

Hi @hmeltonPSL,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.

[v-kpoloju-msft]

Hi @hmeltonPSL,

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[Sergii24 · Accepted solution]

Hi @hmeltonPSL, have you tried the "Edit Interactions" setting? Change how visuals interact in a report - Power BI | Microsoft Learn

I don't think there is a way to condittionally disable a button. You can play around with visual properties to make it invisible or change text when value from the wrong table is selected.

Alternatively, you can create a border that combines together the button with the right table, so users see the related items. It won't prevent them from clicking on it when wrong table is filtered, but will help those who want to get a necessary result rather focus on bugs 🙂

Good luck with your ptoject!

[hmeltonPSL]