2 targets for host.applyJsonFilter

adeepak7 — Tue, 02 Oct 2018 15:08:44 GMT

Respected Amin,

I am using the following code snippet:

const target = {
    //Table name
    table: this.column[0].queryName.substr(0, this.column[0].queryName.indexOf('.')),

    //First field in the table which we want to apply filter on:
    column: this.column[0].queryName.substr(this.column[0].queryName.indexOf('.') + 1)
};

//Checking for the name.
console.log("Table: " + target.table  + "\nColumn: " + target.column);

  let filter = new models.AdvancedFilter(
    target,
    "And",
    {
      operator: "Is",
      value: text
    }
  );
  let action = FilterAction.merge;
  this.searchBox[0].value = text;

this.host.applyJsonFilter(filter, "general", "filter", action);

I want to apply filter on the table for 2 columns. That means I will have to use an API that takes 2 targets and filter as arguments.

Is there any solution available for this usecase? In short, I want to apply filter on 2 columns of same table.

Re: 2 targets for host.applyJsonFilter

v-viig — Wed, 03 Oct 2018 09:43:29 GMT

Multi column filters are not supported. Current target is end of this year to bring such feature.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: 2 targets for host.applyJsonFilter

andres777 — Fri, 27 Sep 2019 21:53:56 GMT

Multi column filters : Now they are supported!

https://docs.microsoft.com/en-us/power-bi/developer/visuals/filter-api

topic Re: 2 targets for host.applyJsonFilter in Developer

2 targets for host.applyJsonFilter

Re: 2 targets for host.applyJsonFilter

Re: 2 targets for host.applyJsonFilter