topic Re: Sync between custom filter and slicer in Developer

Sync between custom filter and slicer

ysapiyev — Mon, 26 Mar 2018 10:09:15 GMT

Hi everyone,

I have custom visual which filters date and I also have regular slicer with date with date input and slider.

It looks like this:

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.

How can I make date input values change and slider, by using my custom visual?

Regards,

Yerkhan

Re: Sync between custom filter and slicer

v-chuncz-msft — Tue, 27 Mar 2018 09:23:20 GMT

@ysapiyev,

Take a good look at Adding Selection and Interaction with Other Visuals.

Re: Sync between custom filter and slicer

v-viig — Tue, 27 Mar 2018 14:34:56 GMT

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.

We would recommend to start using Advanced Filter API.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Sync between custom filter and slicer

ysapiyev — Wed, 28 Mar 2018 06:08:04 GMT

@v-viig,

I'm using selection manager.

To use advanced filter API, I should updateOnRangeSelectionChange formula with my own conditions, right? What it will return?

Regards,

Yerkhan

Re: Sync between custom filter and slicer

v-viig — Thu, 29 Mar 2018 13:14:06 GMT

You are correct. The updateOnRangeSelectonChange should be modified but it will return nothing as type is void.

The purpose of this function is to generate an IAdvancedFilter and apply it via applyAdvancedFilter.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Sync between custom filter and slicer

ysapiyev — Thu, 29 Mar 2018 17:15:46 GMT

@v-viig,

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.

Regards,

Yerkhan.

Re: Sync between custom filter and slicer

v-viig — Fri, 30 Mar 2018 08:17:05 GMT

Yes, I think so.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Sync between custom filter and slicer

ysapiyev — Fri, 30 Mar 2018 11:53:10 GMT

@v-viig,

I'm quite confused about usage of Advanced filter.

In updateOnRangeSelectonChange there are several functions, which are located in sampleslicer.ts. Should I copy them to my code? Are they necessary?

I also tried to build filter using powerbi-models but import of powerbi-models failed with error: "import cannot have reference to module". How it can be resolved?

Regards,

Yerkhan

Re: Sync between custom filter and slicer

ysapiyev — Sun, 01 Apr 2018 06:55:26 GMT

@v-viig,

I understood how to use advanced filter. However, I've faced new issue:

when I don't use date input, everything works fine:

However, when I use date input, it stops changing.

How it can be fixed?

Regards,

Yerkhan

Re: Sync between custom filter and slicer

v-viig — Mon, 02 Apr 2018 11:55:42 GMT

Could you please clarify what data input is? Are you talking about Power BI Slicer?

Currently we would recommend to open Chrome Developer Tools and turn on "Pause on exceptions" in the Sources tab.

After that, try to replicate the issue and see if debugger will catch an exception in the code.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com