Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

After Advance Filtering, other visuals not getting exact filtered values.

Hi, 

I am using Advance JsonFilter to filter numbers between a range

     let conditions: IAdvancedFilterCondition[] = [];
    conditions.push({
        operator: "GreaterThanOrEqual",
        value: valueRange[0]
    }); 
    conditions.push({
        operator: "LessThanOrEqual",
        value: valueRange[1]
    });
    let filter = new AdvancedFilter(this.filterTarget, "And", conditions);

    this.host.applyJsonFilter(filter, "general", "filter", powerbi.FilterAction.merge);

The filtered data is accurate from the filter visual point of view

But data range in other visuals is not in the same range as we filtered

 

 

It should start from -99999 but it is giving from -99900 only.

Is this a bug? Or is there anything I am missing?

Thanks for any help!

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks for the reply.

      instead of directly using the AdvancedFilter like this
      let filter = new AdvancedFilter(this.filterTarget, "And", conditions);

      Sample Slicer used
      let filter: IAdvancedFilter = { $schema: "http://powerbi.com/product/schema#advanced", ...(new AdvancedFilter(this.filterTarget, "And", conditions)) }

      I made the changes and checked but this did not solve my issue.

      To be precise
      The visual is not filtering values in the level of ten's. 101 to 199 are rounding to 100 and so on