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.
Hey,
I'm trying to build a new version of our custom visual because I saw other custom visuals (apparently) applying json filters to themself. How can I achive this behaviour and apply a json filter (advanced filter api) to the visual itself which created the filter?
regards,
lucmax
Solved! Go to Solution.
With help of a fellow forum member I got it to work the way I want. You need to do the following to have your visual filter itself AND others visuals:
capabilities.json (general)
"properties": {
"filter": {
"type": {
"filter": true
}
},
"selfFilter": {
"type": {
"filter": {
"selfFilter": true
}
}
}
}
ApplyJsonFilter call(s)
this._visualHost.applyJsonFilter(
filterList,
"general",
"selfFilter",
powerbi.FilterAction.merge
);
this._visualHost.applyJsonFilter(
filterList,
"general",
"filter",
powerbi.FilterAction.merge
);
Hope this helps someone else!
With help of a fellow forum member I got it to work the way I want. You need to do the following to have your visual filter itself AND others visuals:
capabilities.json (general)
"properties": {
"filter": {
"type": {
"filter": true
}
},
"selfFilter": {
"type": {
"filter": {
"selfFilter": true
}
}
}
}
ApplyJsonFilter call(s)
this._visualHost.applyJsonFilter(
filterList,
"general",
"selfFilter",
powerbi.FilterAction.merge
);
this._visualHost.applyJsonFilter(
filterList,
"general",
"filter",
powerbi.FilterAction.merge
);
Hope this helps someone else!
Hi, I'm also looking for a way to filter my cutom visual and not just the other visuals.
This query seems to be the closest I can find to what I'm lookng for.
I have the capabilities setup as mentioned, but not sure how and where the applyJSONFilter call is implemented.
Can someone assist me with the steps in order to implement this or direct me to an example as to how this is done?
Hi @Charlene,
we are calling the applyJsonFilter in our visual.ts code when the user clicks our filter button. The filter list contains the filters we want to apply in a format like this:
{
$schema: "http://powerbi.com/product/schema#basic",
...new BasicFilter(
{
table: tableName
column: columnName,
},
"In",
values
),
}
Maybe this helps.
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 |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 |