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

      • 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