Custom visual and filtering?

Hi MartijnBre,

With the detail provided, things almost look OK but your capabilities aren't set up for filtering. You have the dynamic format string functionality available, but you should have your general object at least set up as follows to tell Power BI that your visual is permitted to filter the data model:

{
    ...
    "objects": {
        "general": {
            "displayName": "General",
            "properties": {
                "filter": {
                    "type": {
                        "filter": true
                    }
                }
            }
        },
        ...
    }
    ...
}

Regarding your code, consider the table name, column name and values are present in your model. If not, then Power BI may not apply the filter, as it will determine it not to be a valid query and will save resources.

One final tweak: your applyJsonFilter call should be as follows, based on the above capabilites configuration:

    this.host.applyJsonFilter(
      filter,
      "general",
      "filter",
      powerbi.FilterAction.merge
    );

Note parameters 2 and 3 refer to object name and property name (which is where Power BI should persist the filter in your visual capabilities), not table and column name (these are already in the filter criteria).

I made these changes in a brand new visual and the filter worked as expected. Hopefully, this is all you need to get moving again.

Good luck!

Daniel