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.
Hi, I was trying to implement the advance filter as shown for the sampleSlicer for API 1.7.0. This works great.
My question is now is it also possible to filter on measures, since I found the target IFilterMeasureTarget for the target value. If yes what do I have to put for table and measure for the target values?
Looking forward to an answer, thanks.
With Regards
Asamah
Hello @Capono
I think that you should use something like this:
let valueColumn: DataViewValueColumn = this.dataView.categorical.values[0]; let target: IFilterColumnTarget = { table: valueColumn.source.queryName.substr(0, valueColumn.source.queryName.indexOf('.')), column: valueColumn.source.displayName }; return target;
Please let me know if this code resolves the issue.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Have you tried something like this?
let valueColumn: DataViewValueColumn = this.dataView.categorical.values[0]; let target: IFilterMeasureTarget = { table: valueColumn.source.queryName.substr(0, valueColumn.source.queryName.indexOf('.')), measure: valueColumn.source.queryName, }; return target;
Please let me know if that works. Otherwise, it'd be better to create a question at powerbi-models GitHub repository.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Thanks, for your time. This didn't work there should be a documentation how to use this.
It'd be good if you could create an issue at Power BI Models GitHub.
There're experienced developers who develop and support the Advanced Filter.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
I did try the above approach but its not working for me aswell.
Where can I find proper documentation to implement
IFilterMeasureTarget
We'd recommend to request assistance via this form.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals