topic Re: Cusstom Visual refresh dataset in Custom Visuals Development Discussion

Cusstom Visual refresh dataset

Anonymous — Fri, 20 Sep 2019 03:39:05 GMT

Hello.

I have a custom visual with a slicer filter and an svg element with nodes and links(please see image below)

I have an onclick event in the circle, I have the selectionId for the element

selectionManager.select(d.selectionId);

I need to refresh the options.dataview[0], in order to refresh the data and refresh my svg element.

What do you recommend to have this functionality?

Is it possible to update the metric name slicer selected value?

Please help, thank you.

PowerBI SVG

v-evelk — Tue, 01 Oct 2019 15:03:33 GMT

Hello,

Sorry for the late answer.

I see that my colleague has already answered you by e-mail so, I will transfer his answer here.

"If you try to filter data in slicer, that works with metrics -- it's impossible.

Visuals can't filter data in slicer visuals by using SelectionID's.

You need to use Filter API:

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Anonymous — Tue, 01 Oct 2019 20:34:11 GMT

hello,

I've apply a basic filter using this code:

//Apply a Basic filter

var basicFilter : IBasicFilter = {

target: {

table: "Dim_MetricRelationships",

column: "Metric Branch"

operator: "In",

//values: ['Excess M&S', 'PO Compliance - Inventory'],

values: Visual.metricList,

filterType: models.FilterType.Basic

};

this.host.applyJsonFilter(basicFilter, "general", "filter", FilterAction.merge);

How can I refresh the data based on this basicfilter?

Right now If I see values on options.dataViews[0] I only see data for one metric.

I need to be able to get the data based on this new filter.

Please let me know your comments. thank you!

Anonymous — Mon, 07 Oct 2019 20:53:32 GMT

Hello,

after call applyJsonfilters, how can I update the data in options.dataViews[0] ?