Custom Slicer: applyJsonFilter not working after pbiviz package

[Anonymous]

Hello beforehand thanks for your help.

I am developing a custom calendar slicer, it already works as intended on developer mode at powerbi web. The problems is when I use pbiviz pakage and import the visual from file it doesn't filter the other visuals in the page, as it does in developer mode.

This is how I am building the filter and I have already added the filter property to capabilities.json.

this.host.applyJsonFilter(null, "dataPoint", "filter", FilterAction.merge);

const target: models.IFilterColumnTarget = {
      table: this.column.source.queryName.substr(0, this.column.source.queryName.indexOf('.')), // table
      column: this.column.source.displayName // col1
};

let conditions: models.IAdvancedFilterCondition[] = [];
if (data) {
      conditions.push({
          operator: "GreaterThanOrEqual",
          value: data[0].fecha.toDate().toJSON()
      });

      conditions.push({
           operator: "LessThanOrEqual",
           value: data[data.length - 1].fecha.toDate().toJSON()
      });
}

const filter = new models.AdvancedFilter(target, "And", conditions)
this.host.applyJsonFilter(filter, "dataPoint", "filter", FilterAction.merge);

I have also added this to the capabilities.json:

"objects": {
        "dataPoint": {
            "properties": {
               ...
                "filter": {
                    "type": {
                        "filter": true
                    }
                }
            }
       }
}

[Anonymous · Accepted solution]

Thanks @V-lianl-msft, as shown the blog you shared the solution was on changing dataPoint to general, in capabilities.json and in every call of applyJsonFilter.

[V-lianl-msft]

Hi @Anonymous ,

Please check your visual.ts and you could refer to this blog.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.