topic Re: Advanced filter for array selection in Developer

Advanced filter for array selection

Anonymous — Tue, 24 Dec 2019 05:52:09 GMT

Hello everybody,

I wanted to use advanced filter for array selection, but I have some difficulties. I used following code for date selection:

this.applyDatePeriod(this.start_var, this.end_var, target, true); public applyDatePeriod(startDate: Date, endDate: Date, target: IFilterColumnTarget, isUserSelection: boolean): void { this.applyFilter(isUserSelection); // If startDate and EndDate is null then ClearSelection is triggered const filter: IAdvancedFilter = new window["powerbi-models"].AdvancedFilter( target, "And", { operator: "GreaterThan", value: startDate ? startDate.toJSON() : null }, { operator: "LessThan", value: endDate ? endDate.toJSON() : null }); this.host.applyJsonFilter( filter, "general", "filter", (startDate && endDate) ? FilterAction.merge : FilterAction.remove ); }

How can I use same approach for array selection?

Thanks.

Regards,

Yerkhan

Re: Advanced filter for array selection

v-yuta-msft — Thu, 26 Dec 2019 06:01:44 GMT

@Anonymous ,

You can refer to the sample code here.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Advanced filter for array selection

Anonymous — Thu, 26 Dec 2019 06:08:43 GMT

@v-yuta-msft Hello

Thanks for your answer. But this is not exactly what I'm looking for. I need custom visual.

Regards,

Yerkhan

Re: Advanced filter for array selection

v-yuta-msft — Thu, 26 Dec 2019 07:01:57 GMT

@Anonymous ,

It seems there's no "array" section in the advanced filter object model. You can refer to the model source code.

https://microsoft.github.io/PowerBI-visuals/tutorials/building-slicer-visual/using-the-advanced-filter-api/

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Advanced filter for array selection

Anonymous — Fri, 27 Dec 2019 05:45:25 GMT

@v-yuta-msft

Ok, I got it. Thanks anyway.

Regards,

Yerkhan