Forum Discussion

hmeltonPSL's avatar
hmeltonPSL
Helper II
10 months ago
Solved

Button Should only interact with one visual

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 i...
  • Sergii24's avatar
    10 months ago

    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's avatar
    10 months ago

    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=powerbi-desktop 

    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.