Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Advanced filter for array selection

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

4 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    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.