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

[JeremyyLin]

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!

[Anonymous]

Hi @JeremyyLin ,

Please review the following links, hope they can help you.

The Visual Filters API in Power BI visuals

Using the Advanced Filter API

Best Regards

[JeremyyLin]

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