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.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

6 Replies

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

    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

    [email protected]

    • nhuzaa's avatar
      nhuzaa
      Frequent Visitor
      8 years ago
        target: {
    table: "Products",
    column: "Version"
  },

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

      • 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]