Apply JSON Filter to own custom visual

[lucmax]

Hey,

I'm trying to build a new version of our custom visual because I saw other custom visuals (apparently) applying json filters to themself. How can I achive this behaviour and apply a json filter (advanced filter api) to the visual itself which created the filter?

regards,

lucmax

[lucmax · Accepted solution]

With help of a fellow forum member I got it to work the way I want. You need to do the following to have your visual filter itself AND others visuals:

capabilities.json (general)

            "properties": {
                "filter": {
                    "type": {
                        "filter": true
                    }
                },
                "selfFilter": {
                    "type": {
                       "filter": {
                          "selfFilter": true
                       }
                    }
                 }
            }

ApplyJsonFilter call(s)

    this._visualHost.applyJsonFilter(
      filterList,
      "general",
      "selfFilter",
      powerbi.FilterAction.merge
    );
    this._visualHost.applyJsonFilter(
      filterList,
      "general",
      "filter",
      powerbi.FilterAction.merge
    );

Hope this helps someone else!

[Charlene]

Hi, I'm also looking for a way to filter my cutom visual and not just the other visuals.

This query seems to be the closest I can find to what I'm lookng for.

I have the capabilities setup as mentioned, but not sure how and where the applyJSONFilter call is implemented.

Can someone assist me with the steps in order to implement this or direct me to an example as to how this is done?

[lucmax]

Hi @Charlene,

we are calling the applyJsonFilter in our visual.ts code when the user clicks our filter button. The filter list contains the filters we want to apply in a format like this:

{
  $schema: "http://powerbi.com/product/schema#basic",
  ...new BasicFilter(
    {
      table: tableName
      column: columnName,
    },
    "In",
    values
  ),
}

Maybe this helps.