Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous ,
It seems there's no "array" section in the advanced filter object model. You can refer to the model source code.
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 ,
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.
@v-yuta-msft Hello
Thanks for your answer. But this is not exactly what I'm looking for. I need custom visual.
Regards,
Yerkhan
@Anonymous ,
It seems there's no "array" section in the advanced filter object model. You can refer to the model source code.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |