Custom context menu event not triggered with certain types of filters condition operators

Question

Hello&nbsp;We are using Power BI embedded to display reports, and we have implemented a custom context menu for our visuals. It's working fine except when certain filters are applied.&nbsp;If I apply an advanced filter with "is empty" or "is not empty" the context menu event is never triggered. But if I change to "is blank" or "is not blank" it's working.&nbsp;&nbsp; const newSettings = {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; extensions: [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; command: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; name: "myCustomCommand",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; title: "My custom command",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; extend: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; visualOptionsMenu: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; title: "My custom command",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; };&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; report.updateSettings(newSettings).then(function () {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; report.off("commandTriggered");&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; report.on("commandTriggered", function (event) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let commandDetails = event.detail;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (commandDetails.command == 'myCustomCommand') {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // do stuff&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });

v-lianl-msft · Answer

Hi Olsman&nbsp;,
&nbsp;
Null is the absence of a value ,also the blank ‘cells’ that can be any number of things like an empty text string (2 double quote signs).
Maybe the cells without values in this column are blank instead of null. You can check the cells without values in this column in the query editor and replace them with null or blank.
&nbsp;
Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

olsman · Answer

Hi Liang&nbsp;I think the filters are applied correctly, the question is why are the filters affecting the context menu.&nbsp;If I have applied a filter with "is empty" or "is not empty" the custom context menu is not working.&nbsp;Best regards,Olle Karlsson&nbsp;

v-lianl-msft · Answer

Hi Olsman&nbsp;,
&nbsp;
The context menu is controlled by the main window, and the visual menu only has the option of the menu (by passing the option of the selection ID to trigger the enabling of the data point function for the end user). Getting information or events from this menu (for example, apply filter then callback the context) is not currently supportedBest Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

olsman · Answer

Hi&nbsp;Liang&nbsp;I don't think I describe the problem in a good way 🙂&nbsp;1. Load the report2. Open the context menu on a visual3. Click on my custom context menu item4. The javascript event is triggered&nbsp;😀5. Apply an advanced filter with&nbsp;"is empty"6. Open the context menu and click on my custom item7. The javascript event is not triggered&nbsp;☹️8. Change the filter to "is blank"9. Open the context menu and click on my custom item10. The javascript event is triggered&nbsp;😀&nbsp;Best regardsOlle Karlsson

Forum Discussion

Custom context menu event not triggered with certain types of filters condition operators

4 Replies

Related content

Storage trigger event

Trigger activator action only if condition is met over certain time period

How to Trigger pipeline using Event trigger

Possibility to Import Data from Semantic Model Without Triggering XMLA Read Operation

Pipeline Trigger Type