topic Re: Access filters in Custom Visual in Developer

Access filters in Custom Visual

aarshps — Wed, 03 Jan 2018 12:19:50 GMT

Hi,

I have a custom visual in which I need to access the page filters that are being applied. How can I get the filters from my Custom Visual code?

I am trying to create a custom visual somewhat similar to MAQ software's JSONGrid Viz. I also need to add an additional functionality of have a filter element to control the number of columns in the Viz. That is there will be a multiselect to select the columns for the table.

I'm fairly new to Power BI.

Re: Access filters in Custom Visual

v-chuncz-msft — Thu, 04 Jan 2018 07:19:36 GMT

@aarshps,

You may take a look at Using the advanced filter API and view source code of JSON Grid at https://github.com/maqsoftware/PowerBI-visuals/tree/master/src/CustomVisuals/Published/JSONGrid.

Re: Access filters in Custom Visual

aarshps — Thu, 04 Jan 2018 07:23:51 GMT

I have been looking into the source code.

My doubt is how can I have a multi-select like thing in my application and let the user select a list. Then the visualization that is created should have only the columns in the list selected by the user.

Re: Access filters in Custom Visual

v-viig — Fri, 05 Jan 2018 12:23:41 GMT

Power BI Custom Visuals API doesn't support the ability to get filters that are applied on the page.

Could you please explain the second feature a bit deeper?

I also need to add an additional functionality of have a filter element to control the number of columns in the Viz. That is there will be a multiselect to select the columns for the table.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Access filters in Custom Visual

aarshps — Tue, 09 Jan 2018 15:45:23 GMT

Please click to see the image

I've attached a link to what I would like to achieve. Based on that multi-select present just beside the visual, the columns need to change dynamically. So what I need to have is the selections from the slicer to the custom visual.

I need to get the values selected for the slicer inside the custom visual's update(). Will I be able to do it?

Re: Access filters in Custom Visual

v-viig — Wed, 10 Jan 2018 07:25:48 GMT

I think that's impossible to achieve since columns must be specified at Fields panel.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Access filters in Custom Visual

aarshps — Wed, 10 Jan 2018 11:05:00 GMT

Thank you for letting me know. But still, I could achieve the same using a matrix visualization. My doubt is, will I be able to achieve it with custom visuals? Somehow? Even the solution might not look clean, can it be done?

Re: Access filters in Custom Visual

jppp — Wed, 10 Jan 2018 19:20:03 GMT

The behavior you describe is default behavior of Power BI: the dataset available in your (custom) visual is already filtered by other filters from the Power BI. So if you filter on one column, only that column is available in your visual. And if you change that slicer that columns (name and values) are available.

Just try and create a 'simple' empty custom visual only with the dataRoles and dataViewMapping defined and look at the data view of the developer visual to see what dataset is available.

-JP