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.
So I have been following the steps that were outlined here https://microsoft.github.io/PowerBI-visuals/docs/concepts/filter-api/#basic-filter-api
I created a basic filter:
Solved! Go to Solution.
Yep, I've realised now thanks.
It turns out the answer was simply to use
visualhost.applyJsonFilter(advancedFilter, "general", "selfFilter", FilterAction.merge);
instead of
visualhost.applyJsonFilter(advancedFilter, "general", "Filter", FilterAction.merge);
This will filter the visual and not all the other visuals.
Hi @Anonymous ,
this.visualHost.applyJsonFilter() pushes the filter back to Power BI so that all other visuals on the page are filtered by the content of the filter. It doesn't filter the data that the visual is getting; slicer are using the same technique.
-JP
Yep, I've realised now thanks.
It turns out the answer was simply to use
visualhost.applyJsonFilter(advancedFilter, "general", "selfFilter", FilterAction.merge);
instead of
visualhost.applyJsonFilter(advancedFilter, "general", "Filter", FilterAction.merge);
This will filter the visual and not all the other visuals.
Hey @Anonymous ,
I'm trying to achieve exactly the behaviour and have my custom visual filter itself. I can't get your solution to work, did you do any other changes regarding for example the capabilities?
regards,
lucmax
Hey lucmax,
So you need to add selfFilter to your general capabilities too. Like this. So instead of filter, replace with selfFilter. There is no documentation for this, so it was a lot of trial and error.
Thank you @Anonymous! That helped a lot. I tried changing them, but didn't do it with the double "selfFilter" key.
Hello.
Can you please share your current repository project?
Right now I'm facing an issue with FilterAction.merge
@Anonymous wrote:Yep, I've realised now thanks.
It turns out the answer was simply to use
visualhost.applyJsonFilter(advancedFilter, "general", "selfFilter", FilterAction.merge);
instead of
visualhost.applyJsonFilter(advancedFilter, "general", "Filter", FilterAction.merge);
This will filter the visual and not all the other visuals.
@Anonymous wrote:Yep, I've realised now thanks.
It turns out the answer was simply to use
visualhost.applyJsonFilter(advancedFilter, "general", "selfFilter", FilterAction.merge);
instead of
visualhost.applyJsonFilter(advancedFilter, "general", "Filter", FilterAction.merge);
This will filter the visual and not all the other visuals.
You need to add this to the top to import FilterAction
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.