Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello beforehand thanks for your help.
I am developing a custom calendar slicer, it already works as intended on developer mode at powerbi web. The problems is when I use pbiviz pakage and import the visual from file it doesn't filter the other visuals in the page, as it does in developer mode.
This is how I am building the filter and I have already added the filter property to capabilities.json.
this.host.applyJsonFilter(null, "dataPoint", "filter", FilterAction.merge);
const target: models.IFilterColumnTarget = {
table: this.column.source.queryName.substr(0, this.column.source.queryName.indexOf('.')), // table
column: this.column.source.displayName // col1
};
let conditions: models.IAdvancedFilterCondition[] = [];
if (data) {
conditions.push({
operator: "GreaterThanOrEqual",
value: data[0].fecha.toDate().toJSON()
});
conditions.push({
operator: "LessThanOrEqual",
value: data[data.length - 1].fecha.toDate().toJSON()
});
}
const filter = new models.AdvancedFilter(target, "And", conditions)
this.host.applyJsonFilter(filter, "dataPoint", "filter", FilterAction.merge);
I have also added this to the capabilities.json:
"objects": {
"dataPoint": {
"properties": {
...
"filter": {
"type": {
"filter": true
}
}
}
}
}
Solved! Go to Solution.
Thanks @V-lianl-msft, as shown the blog you shared the solution was on changing dataPoint to general, in capabilities.json and in every call of applyJsonFilter.
Thanks @V-lianl-msft, as shown the blog you shared the solution was on changing dataPoint to general, in capabilities.json and in every call of applyJsonFilter.
Hi @ArturoRR97 ,
Please check your visual.ts and you could refer to this blog.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.