Advanced filter for array selection

[Anonymous]

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

[v-yuta-msft]

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

[Anonymous]

@v-yuta-msft Hello

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

Regards,

Yerkhan

[v-yuta-msft · Accepted solution]

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

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.

[Anonymous]

@v-yuta-msft 

Ok, I got it. Thanks anyway.

Regards,

Yerkhan