Forum Discussion

nhuzaa's avatar
nhuzaa
Frequent Visitor
8 years ago

Filter a measure column using AdvanceFilter

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...
v-viig's avatar
v-viig
Community Champion
8 years ago

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

[email protected]

nhuzaa's avatar
nhuzaa
Frequent Visitor
8 years ago

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

  • v-viig's avatar
    v-viig
    Community Champion
    8 years ago

    I'll check it out and get back.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

    • v-viig's avatar
      v-viig
      Community Champion
      8 years ago

      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

      [email protected]