Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a custom slicer I wrote that filters dates. It's pretty basic, you just give it a date field and it lets you filter the report down to a single date. The issue I'm having with it is if I select a date, the report filters down correctly. If I then hide the visual it loses the selection and the filter is gone.
I'm having trouble finding documentation on what's happening behind the scenes when it's hidden. Can anyone give me some insights into what's going on and if there is some type of special handling for this secenario?
Thanks
Solved! Go to Solution.
Hi @cboneill0099 ,
Seems it act like a visual interaction instead of filter, please try to added the Advanced Filter API based on this similar thread: https://community.powerbi.com/t5/Developer/Custom-Slicer-Selection-Issue/td-p/371992
Best regards,
Hi @cboneill0099 ,
Seems it act like a visual interaction instead of filter, please try to added the Advanced Filter API based on this similar thread: https://community.powerbi.com/t5/Developer/Custom-Slicer-Selection-Issue/td-p/371992
Best regards,
I attempted to use the filtering API and it solved half of my problem. Now, when I hide the visual the filter does not go away, but when I make the visual visable again, the filter gets lost. Is there something I should be doing to persist the filter behind the scenes and reload it when making the visual visable again?
Here is my code in the update method:
let filterTarget: IFilterColumnTarget = {
table: categories.source.queryName.substr(0, categories.source.queryName.indexOf('.')),
column: categories.source.displayName
};
const basicFilter: IBasicFilter = {
$schema: "http://powerbi.com/product/schema#basic",
// target: {
// table:"Date",
// column:"CalendarYear"
// },
target: filterTarget,
operator: "In",
values: [dateSelectionValue], //[2019],
filterType: FilterType.Basic
}
this.visualHost.applyJsonFilter(basicFilter, "general", "filter", FilterAction.merge);
This is what I added to the capabilities file:
"general": {
"displayName": "General",
"displayNameKey": "formattingGeneral",
"properties": {
"filter": {
"type": {
"filter": true
}
},
"selfFilter": {
"type": {
"filter": {
"selfFilter": true
}
}
}
}
}
Thank you
There was an error in my code causing the filter to get lost. The above solution worked for me.
Thank you.
Thank you. I'll give that a shot.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
16 | |
11 | |
5 | |
4 | |
3 |