Sync between custom filter and slicer

Question

Hi everyone,&nbsp;I have custom visual which filters date and I also have regular slicer with date with date input and slider.It looks like this:&nbsp;&nbsp;In left I have custom filter which selects specific range and on right I have regular slicer. Even though, I set interaction between them, regular slicer doesn't change.&nbsp;How can I make date input values change and slider, by using my custom visual?&nbsp;&nbsp;Regards,Yerkhan

v-chuncz-msft · Answer

ysapiyev,
&nbsp;
Take a good look at&nbsp;Adding Selection and Interaction with Other Visuals.

v-viig · Answer

How do you apply selection/filter in your custom visual?
The slicer doesn't react on any kind of selection if is's applied via SelectionManager.
&nbsp;
We would recommend to start using Advanced Filter API.
&nbsp;
Ignat Vilesov,
Software Engineer
&nbsp;
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

ysapiyev · Answer

v-viig,&nbsp;I'm using selection manager.&nbsp;&nbsp;To use advanced filter API, I should updateOnRangeSelectionChange formula with my own conditions, right? What it will return?&nbsp;Regards,Yerkhan&nbsp;

v-viig · Answer

You are correct. The&nbsp;updateOnRangeSelectonChange should be modified but it will return nothing&nbsp;as type is void.
The purpose of this function is to generate an&nbsp;IAdvancedFilter and apply it via&nbsp;applyAdvancedFilter.
&nbsp;
Ignat Vilesov,
Software Engineer
&nbsp;
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

ysapiyev · Answer

v-viig,&nbsp;I've found some code:const relativeDateFilter: pbi.models.IRelativeDateFilter = {
  $schema: "http://powerbi.com/product/schema#relativeDate",
  target: {
    table: "Sales",
    column: "OrderDate"
  },
  operator: pbi.models.RelativeDateOperators.InLast,
  timeUnitsCount: 30,
  timeUnitType: pbi.models.RelativeDateFilterTimeUnit.Days,
  includeToday: true,
  filterType: pbi.models.FilterType.RelativeDate
};Can I use it in filter? I want to be able to select last week. month, year.&nbsp;Regards,Yerkhan.

Forum Discussion

Sync between custom filter and slicer

9 Replies

Related content

Customer Scorecard

Filter

Custom Visual

Filtering a Custom Column

Custom date filter