topic Re: I want to filter the measure target not the column target in Custom Visuals Development Discussion

Filter a measure column using AdvanceFilter

nhuzaa — Thu, 14 Jun 2018 15:32:29 GMT

I followed the steps on https://github.com/Microsoft/powerbi-visuals-sampleslicer However the columns I want to filter is a Measure not Grouping.

I came across IFilterMeasureTarget https://microsoft.github.io/powerbi-models/interfaces/models.ifiltermeasuretarget.html Tried the following

   callbacks.getAdvancedFilterColumnTarget = (): IFilterMeasureTarget=> {
            let valueCol: DataViewValueColumn= this.dataView.categorical.values[0];
            let target: IFilterMeasureTarget = {
                table: valueCol.source.queryName.substr(0,valueCol.source.queryName.indexOf('.')),
                measure: valueCol.source.queryName,
            };

            return target;
        };

But its not working

Re: Filter a measure column using AdvanceFilter

v-viig — Thu, 14 Jun 2018 16:29:19 GMT

We'd recommend to try to use BasicFilter instead of AdvancedFilter.

const basicFilter: models.IBasicFilter = {
  target: {
    table: "Products",
    column: "Version"
  },
  operator: "In",
  values: [
    1,
    2,
    3,
    4
  ]
};

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Filter a measure column using AdvanceFilter

nhuzaa — Thu, 14 Jun 2018 17:59:19 GMT

  target: {
    table: "Products",
    column: "Version"
  },

What should be there for the table and column key for the measure columns ?

Re: Filter a measure column using AdvanceFilter

v-viig — Fri, 15 Jun 2018 06:38:20 GMT

We'd recommend to take a look at this code to figure out how to populate table and column name.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

I want to filter the measure target not the column target

nhuzaa — Wed, 20 Jun 2018 16:23:55 GMT

I want to user

IFilterMeasureTarget not IFilterColumnTarget because I want to filter the measure not the category. How do i get the measure and table values. Approach I am following is below but its not working

 let target: IFilterMeasureTarget = {
                table: valueCol.source.queryName.substr(0,valueCol.source.queryName.indexOf('.')),
                measure: valueCol.source.queryName,
            };

What is the correct approach to get the
table and measure value

Re: I want to filter the measure target not the column target

v-viig — Fri, 22 Jun 2018 07:23:42 GMT

I'll check it out and get back.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: I want to filter the measure target not the column target

v-viig — Fri, 22 Jun 2018 15:41:51 GMT

It seems you can use column target instead of measure.

Have you tried such solution?

const min: number = 100;
const max: number = 101;

if (!this.dataView) {
    return;
}

const source = this.dataView.categorical.values[0].source;

let conditions: IAdvancedFilterCondition[] = [];

if (min) {
    conditions.push({
        operator: "GreaterThan",
        value: min
    });
}

if (max) {
    conditions.push({
        operator: "LessThan",
        value: max
    });
}

const query: string[] = /\((\w+).(\w+)\)/.exec(source.queryName);

let target: IFilterColumnTarget = {
    table: query[1],
    column: query[2],
};

let filter: IAdvancedFilter = new window['powerbi-models'].AdvancedFilter(target, "And", conditions);
this.host.applyJsonFilter(filter, "general", "filter", FilterAction.merge);

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com