Forum Discussion

lucmax's avatar
lucmax
Helper II
6 years ago
Solved

Apply JSON Filter to own custom visual

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

Custom visual
Filtering
  • lucmax's avatar
    lucmax
    6 years ago

    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!

3 Replies

  • lucmax's avatar
    lucmax
    Helper II
    6 years ago

    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's avatar
      Charlene
      Frequent Visitor
      4 years ago

      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's avatar
        lucmax
        Helper II
        4 years ago

        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.